faqts : Computers : Programming : Languages : Sql

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

15 of 24 people (63%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

is there any way to specify the rows that you want returned from a query - (ex. - get me rows # 31 - 45)

Jun 26th, 2001 05:16
Iain Bruce, Jeff Lynch, www.mysql.com


If you're using MySQL you can use:
select * from table LIMIT 5,10;
which would retrieve rows 6-15.
Hope this helps