问题如题;
举例如下:
MySQL:select * from mytable where year>1995 limit 10 order by id desc
SqlServer:select top 10 * from mytable where year>1995 order by id desc
各位高手,请问对应的 Oracle 语句该如何写法?
select * from (select * from mytable where year>1995 order by id desc) t where rownum<11