how to translate this to mysql
with t1 as (select rownum r,id from catalog order by a,b,c)
select id from t1 where r=(select r from t1 where id=13)+1
this sql returns next row. how to write in mysql?
Edited 2 time(s). Last edit at 10/20/2006 02:06AM by bomb_zj none.
Subject
Views
Written By
Posted
how to translate this to mysql
3686
October 20, 2006 01:17AM
2330
October 20, 2006 01:51AM
2280
October 20, 2006 08:33AM
2157
October 20, 2006 10:21PM
2099
October 20, 2006 11:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.