oracle 数据库查询 看来要用到group by,懒得想。 你可以转发到oracle论坛,那里高手多。http://community.csdn.net/expert/deeptree/RoomForum.asp?bigroomid=61 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 oracle 基础和管理 论坛http://community.csdn.net/expert/deeptree/RoomForum.asp?roomid=6101 表news,有字段id,bt(标题),sj(时间),lb(类别)select t.* from (select news.*,rank() over(partition by lb order by sj desc) rk from news) twhere rk<=10; select id,bt,sj,lb from (select (rank() over (partition by lb order by lb asc,sj desc)) rk,id,bt,sj,lb)where rk<=10; select id,bt,sj,lb from (select news.*,rank() over(partition by lb order by sj desc) rk from news) twhere rk<=10 order by lb; 提示出错:ORA-00439:未启用特征:OLAP WINDOW FUNCTIONS,该怎么处理。 不支持分析函数。try:select * from news twhere (select count(*) from news tt where tt.sj<=t.sj and t.lb=tt.lb)<11; oracle索引问题 imp导入数据错误,请帮忙 请问有没有sql语句可以获得表的创建脚本语句 有关数据库链路问题请指教 求助ora-04030内存分配不足 oracle字符集(急),pl/sql显示问号 请教 ORA-03114 未连接到ORACLE 问题 ORACLE乱码问题 …………效率问题:保存一位数字用char(1) 还是Number(1),那种更适合? orcale时间转换问题 关于oracle数据库查询 如何复制包含大字段的表的结构和数据
http://community.csdn.net/expert/deeptree/RoomForum.asp?roomid=6101
select t.* from
(select news.*,rank() over(partition by lb order by sj desc) rk from news) t
where rk<=10;
select (rank() over (partition by lb order by lb asc,sj desc)) rk,id,bt,sj,lb)
where rk<=10;
(select news.*,rank() over(partition by lb order by sj desc) rk from news) t
where rk<=10 order by lb;
try:
select * from news t
where (select count(*) from news tt where tt.sj<=t.sj and t.lb=tt.lb)<11;