|
Using MySQL's LIMIT Command to Control Returned RowsAverage Rating: 3.8/5 | Rate this item | 50 users have rated this item.
|
Expertise: Intermediate
Language: MySQL
April 7, 2008
Using MySQL's LIMIT Command to Control Returned Rows
Use the following script to select a particular number of rows after a certain row in MySQL:
SELECT * FROM tblDummy LIMIT 15, 30
This script returns the first 30 rows after row 15 in the tblDummy table.
Srinath MS
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible. Submit your tip here.
| 
Digg
del.icio.us
Newvine
furl
StumbleUpon
BlinkList
Newsvine
Magnolia
Facebook
Tailrank
Slashdot
Technorati
Google Bookmarks
Yahoo Favorites
Windows Live
Ask
