abdelelbouhy Posted January 22, 2011 Share Posted January 22, 2011 hello,how can i return only 10 rows from the middle of the table for example from row 10 to row 20thanx Link to comment Share on other sites More sharing options...
Rough Divide Posted January 22, 2011 Share Posted January 22, 2011 SET ROWCOUNT = 10;SELECT TOP 20 * FROM table;(returns rows 10-20) Link to comment Share on other sites More sharing options...
birbal Posted January 22, 2011 Share Posted January 22, 2011 Top dont work with mysql you may use limit insteadSELECT * FROM table LIMIT 10,20 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.