面试题!求解 表名为tab_1,其中有一个字段为code,写一条select按code从小到大排序的前10条记录并按code 从大到小排序。(查出表的所有字断) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from (select t.*,row_number() over(order by code) rn from tab_1)where rn <= 10order by code desc; select * from (select * from A order by code) where rownum < 11 order by code desc select * from(select * from tab_1 where rownum<11 order by code asc) t order by code desc select * from tab_1 where rownum <11 order by code asc执行顺序是 select * from tab_1 where rownum <11再order by 你能查出正确结果才怪!select * from (select * from tab_1 order by coude) where rownum<11 order by code DESC; 面试题知道的大哥说下 问一Oracle大致算法 ,分不够再加,先谢过了 求一个存储过程!导出用户!!!急急!!!!!! oracle查询问题 数字或值错误: 字符串缓冲区太小 高分求救一oracle数据库的启动问题???? 求ORACLE8.1.7.4的缓冲区溢出漏洞补丁(for linux和WIN2000的都要) Oracle数据库维护一般有哪些工作?具体流程有哪些?谢谢! 这个sql如何写 谢谢!如果提的问题没有水准!还请大虾见谅!:( oracle10gTNS-12545:因目标主机或对象不存在,连接失败 已经有数据的表这么加如一列(自动增加的ID号)
(select t.*,row_number() over(order by code) rn from tab_1)
where rn <= 10
order by code desc;
执行顺序是 select * from tab_1 where rownum <11再order by
select * from (select * from tab_1 order by coude) where rownum<11 order by code DESC;