17,089
社区成员
发帖
与我相关
我的任务
分享
select * from
(select ID ,name ,k_time,sum(score) score from a)
where rownum<=3
order by score;
SELECT CASE WHEN to_char(sysdate,'D')='1' THEN 7 ELSE TO_NUMBER(TO_CHAR(SYSDATE,'D'))+1 END DAY FROM DUAL
SELECT * FROM
(SELECT ID , NAME , COUNT(ID) CNT
FROM a
GROUP BY ID
ORDER BY CNT DESC) WHERE ROWNUM <=3;