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 PROTECTED]
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 PROTECTED]
Hi,
What is the alternative in mysql for ROWNUM of Oracle?
Thanks,
Rama Raju
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request