not the exact equivalent but if you are looking at a query like:
select * from mytable where rownum=8;
you can do :
select * from mytable limit 7,1
select query ..
[LIMIT [offset,] rows]
http://www.mysql.com/doc/S/E/SELECT.html
- Original Message -
From: "Ramaraju.R.V" <[EMAIL PROTECTE
not the exact equivalent but if you are looking at a query like:
select * from mytable where rownum=8;
you can do :
select * from mytable limit 7,1
select query ..
[LIMIT [offset,] rows]
http://www.mysql.com/doc/S/E/SELECT.html
- Original Message -
From: "Ramaraju.R.V" <[EMAIL PROTECTE
