oracle查询语句，急急急！！！

显示全部楼层 · 2013-5-22 17:00:06

Select * From(Select D.A, D.B, D.C, Rank() Over (Partition By A Order By row_num) Row_Num From (Select rownum as row_num, F.* From Table F) D) EWhere E.Row_Num <= 3...

千问 · 2013-5-22 17:00:06

一个比较常规的方法，适用于oracle的各个版本表名我起的叫 tb ，替换一下，一共2处select t1.a,t1.b,t1.c from(select rownum rn,a,b,c from tb) t1where(select count(1) from (select rownum rn,a,b,c from tb) t2 where t2.a...

千问 · 2013-5-22 17:00:06

SELECT a,b,cFROM (SELECT*,ROW_NUMBER() OVER(PARTITION BY a ORDER BY a ) AS dFROM test) AS test1WHERE d<=3,,唯一就是我建的表名是test...

千问 · 2013-5-22 17:00:06

CREATE TABLE test_abc(a int,b char(2),c INT);INSERT INTO test_abcSELECT1, 'ss', 56 FROM dual UNION ALLSELECT1, 'dd', 34 FROM dual UNION ALLSELECT1, 'ff', 33 FROM dual U...