假设有表
CREATE TABLE Fact_Sale_Profit (
pid number(6),
storeid number(6),
cid number(8),
tdate date,
sale number(8),
profit number(8)
PRIMARY KEY (pid, storeid, cid, tdate)
);给定一个tdate比如:tdate = '2009-12-02' ,有没有办法通过SQL语句得到sale值前5大的pid?
十分感谢!
CREATE TABLE Fact_Sale_Profit (
pid number(6),
storeid number(6),
cid number(8),
tdate date,
sale number(8),
profit number(8)
PRIMARY KEY (pid, storeid, cid, tdate)
);给定一个tdate比如:tdate = '2009-12-02' ,有没有办法通过SQL语句得到sale值前5大的pid?
十分感谢!
谢谢#2!#3:加日期tdate是想知道特定时间的top 5完整的code:select pid
from (select pid, sum(sale) as sumSale from Fact_Sale_Profit where tdate = TO_DATE('2009-12-02', 'yyyy-mm-dd') group by pid order by sumSale desc)
where rownum <= 5;