> >I am having more than 10 records in a table. I want to select only first top 10 records (depending on one >field score) and then want to select 10th position record. > >select * from table1 order by score desc LIMIT 10 > >This will give me 10 records but then how to get the last record ?
Cycle them all until you hit the last one? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
