Re: how to translate this to mysql
hi all:
the sql i wrote is incorrect.
it should be "
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
"
well, how to translate this one to mysql?
thanks.
Edited 1 time(s). Last edit at 10/20/2006 02:07AM by bomb_zj none.
Subject
Views
Written By
Posted
3688
October 20, 2006 01:17AM
Re: how to translate this to mysql
2330
October 20, 2006 01:51AM
2280
October 20, 2006 08:33AM
2157
October 20, 2006 10:21PM
2100
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.