devxlogo

Returning a Certain Number of Rows

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.

See also  Redefining Energy Management: Advanced Solutions for Modern Buildings
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist