select * from table1 order by field1 limit 10,1
Dusan
balaraju mandala napsal(a):
Hi All,
I need a select query, with which i can reach to a particular row
directly.
I mean if a table have 100 rows inserted,
we can use select * from table1 limit 10;
with this query i will have 10 rows, but my requirement is only 10th
row only should come as a result. If u have any solution for this please
share with me.
Thank you.
regards,
Bala Raju M.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]