DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: selecting limited number of records

  1. 04-04-2005, 11:38 AM #1
    vahid
    vahid is offline Registered User
    Join Date
    Apr 2005
    Posts
    2

    selecting limited number of records

    is it posiible to select limited number of records from sql server database?
    there is "limit" and "offset" command in mysql and some other
    databases that aloow it but in MS sql server didn't work.
    Reply With Quote Reply With Quote
  2. 04-04-2005, 01:00 PM #2
    Phil Weber
    Phil Weber is offline Senior Member
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Yes. You may use SET ROWCOUNT and/or SELECT TOP to limit the number of rows returned by a query.
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center