select * from (
SELECT b,c, row_number() OVER( PARTITION BY b ORDER BY c desc) e FROM test_abc) t where e <= 3
SELECT b,c, row_number() OVER( PARTITION BY b ORDER BY c desc) e FROM test_abc) t where e <= 3
转载于:https://www.cnblogs.com/hobby0524/p/8760381.html