need a select query

2007-02-12 Thread balaraju mandala
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

Re: need a select query

2007-02-12 Thread DuĊĦan Pavlica
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

Re: need a select query

2007-02-12 Thread balaraju mandala
Thank you Guys, your answer helpful to me.