Question

一个表中有两个月份的销售记录 取每个月销售量的前三（共6条），大侠帮帮忙 用一条sql语句，Oracle最好

Answer 1

select month,xiaoshou
from 表 a
join (select top 3 month, xiaoshou from 表 c where c.month=a.month order by xiaoshou desc) b on a.month=b.month and a.xiaoshou=b.xiaoshou
--------------------
SELECT * FROM A AS a
WHERE aa in (select top 6 aa from A where bb=a.bb ) ORDER BY aa

以上是两种写法,第二种看起来简单一点

Answer 2

select * from table1 t1 where
(select count(*) from table1 where 月份=t1.月份 and 销售量>t1.销售量)<2

追问

你的结果是对的，谢谢您，如果能把每个月都排序下就好了

追答

select * from table1 t1 where
(select count(*) from table1 where 月份=t1.月份 and 销售量>t1.销售量)<2
order by 月份,销售量

Answer 3

select * from 表一 where rownum <=10
union all
select * from 表二 where rownum <=10

追问

请教下，我查询的是一张表中有两个月份的记录，去每个月份的前三

追答

select * from 表名 where rownum <=3 and to_date(日期,'mm') = 月份一
union all
select * from 表名 where rownum <=3 and to_date(日期,'mm') = 月份二
较久没用过oracle了，也没环境，你试下

Answer 4

select * from
(
select rank()over partition by (t.month order by t.sells desc ) z, t.* from table t
) where z <4
order by t.month, z

Answer 5

第一个月前3的记录 untion all 第二个月前3的记录