17,140
社区成员




SELECT C1, C2, C3 RANK() OVER(ORDER BY C3 DESC) FROM TABLEA
select a.* from TableA a not exists (select 1 from TableA b where a.C3<b.C3)
--不用子查询 是不可能的
select * from TableA where c3=(select max(c3) from tablea)
--或者分析函数
select * from table where c3=MAX(C3)
--估计不行
SELECT B.SID1,B.NAME,
ROW_NUMBER() OVER(ORDER BY B.SID1 desc)
FROM yyq B
WHERE rownum = 1