Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Sep 14, 1999

Returning a Certain Number of Rows

Question:
How do I get a query to return only a certain number of rows? For instance, a search criterion might return 100 rows, but I only want to see them 25 at a time.

I know this was possible when I was messing with Oracle a year and a half ago, but I have yet to see anything about doing it with MySQL.

Answer:
I'm not sure about MySQL but in Microsoft SQL Server, you can issue one of either TOP N records, TOP % records, or plain SET ROWCOUNT to limit the number of records returned.

Still, controlling the number of rows returned is a client-side programming issue. You need a client-side cursor to do this, because doing so at the server will absolutely kill performance for everyone else on the server.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date