select max(rownum) num,username from (select rownum,user_id,username from (select user_id,username from all_users order by 1) ) group by username having username = 'SCOTT'
可以这样啊! create table b as select rownum n,b from a; select n from b where b=56;
(select rownum,user_id,username from
(select user_id,username from all_users order by 1) )
group by username
having username = 'SCOTT'
create table b as select rownum n,b from a;
select n from b where b=56;
有没有可能利用OraDATASET的属性或方法得到?