模拟oracle中的row_num用于排序问题

http://www.2cto.com/database/201108/101982.html

SELECT  @idx2:= @idx2+1 AS idx2, b.* from(

SELECT @idx1:=@idx1+1 AS idx1, t.*

FROM (SELECT @idx1:=0) d1, t_active t order by id desc

) b,(SELECT @idx2:=0)d2 order by name desc

set @idx1:=0;

set @idx2:=0;

select @idx2:=@idx2+1 idx2,b.* from (

SELECT @idx1:=@idx1+1 AS idx1, t.* FROM t_active t order by id desc

) b order by name desc

但是第一种能够在java中运行

而第二种会报错

因为有分号