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

来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/22 01:18:00
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