select * from (select a.*,rownum aa from table a ) where aa=10

来源:学生作业帮助网 编辑:六六作业网 时间:2024/04/28 23:23:07
select*from(selecta.*,rownumaafromtablea)whereaa=10select*from(selecta.*,rownumaafromtablea)whereaa=

select * from (select a.*,rownum aa from table a ) where aa=10
select * from (select a.*,rownum aa from table a ) where aa=10

select * from (select a.*,rownum aa from table a ) where aa=10
select a.*,rownum aa as ab from table a where ab=10