select * from
( select t.*,row_number()over(partition by userid order by userid desc) as num
from table t)
where num<=5
( select t.*,row_number()over(partition by userid order by userid desc) as num
from table t)
where num<=5
解决方案 »
- oracle建job报错
- 数据的备份和恢复
- 求修改oracle中sql语句的执行计划
- ******叶水福物流集团Y3软件公司招聘IT D2K 开发人员 (熟悉 Oracle Developer 2000)******
- 在oracle中 在一张表中 添加一个列 此列是由这张表的另两个字段所组成的 急急急???
- 关于group by的问题
- 奇怪不是我要的结果
- oracle的启动问题!
- oracle 服务器版可以打包到installsheld里面吗?
- 用VC程序实现怎样实现从一个表空间导入到另一个表空间?
- CSDN上各位兄弟,看看OracleServiceXXXX服务会自动停止,实在是找不出原因,快急疯了!!!
- oracle文件系统增长速度很快,该怎么办?很急啊!
( select t.*,row_number()over(partition by userid order by money desc) as num
from table t)
where num<=5
写错了,这个才是!
select * from
( select t.*,row_number()over(partition by trunc(time,'yyyy') order by money desc) as num
from table t)
where num<=5
写不明白,怎么把分类汇总写入到over中呢? 再指点一下。
select *, row_number() over(partition by orderYear order by totalamount desc) as numfrom (select to_char(order_date,'yyyy') orderYear ,customer_id,sum(order_total) totalamount
from orders a
group by to_char(order_date,'yyyy'),customer_id
order by totalamount desc) aawhere num<=5我先把汇总得到,再把子查询放入到from中,对其进行您给写的over中,他说未找到预期的from
?
from orders a
group by to_char(order_date,'yyyy'),customer_id
order by totalamount desc) aawhere num<=5
试看看,我看了下,估计就是.*的问题吧,前面要指定的.
(select customer_id,sum(order_total) from orders group by user_id order by sum(money) desc) t2
where t1.customer_id=t2.customer_id
and t2.rownum <=5
只是他没指定而已,所以FROM找不到了.
我已经给他加上了,不会再有问题了.
group by t.customer_id order by sum(t.order_total) desc
(select aa.*, row_number() over(partition by aa.orderYear order by aa.totalamount desc) as num
from
(
select to_char(order_date,'yyyy') orderYear ,customer_id,sum(order_total) totalamount
from orders a
group by to_char(order_date,'yyyy'),customer_id
order by totalamount desc
) aa) bb
where bb.num<=5