select * from ( select name, fenshu from tb union select nameTwo, fenshuTwo from tb union select nameThree, fenshuThree from tb union select nameFour, fenshuFour from tb union select nameFive, fenshuFive from tb order by 2, 1 ) t where rownum<6;
WITH tmp_score AS (SELECT NAME, fenshu FROM t_test_score UNION ALL SELECT nametwo, fenshutwo FROM t_test_score UNION ALL SELECT namethree, fenshuthree FROM t_test_score UNION ALL SELECT nameFour, fenshuFour FROM T_TEST_SCORE UNION ALL SELECT nameFive ,fenshuFive FROM T_TEST_SCORE) SELECT NAME, SUM(fenshu) s_score FROM tmp_score GROUP BY NAME ORDER BY s_score DESC
select a.name, a.fenshu from ( select name, sum(fenshu) as fenshu from ( select name, fenshu from tb union select nameTwo, fenshuTwo from tb union select nameThree, fenshuThree from tb union select nameFour, fenshuFour from tb union select nameFive, fenshuFive from tb ) t group by name order by fenshu ) a where rownum<6;
select a.name, a.fenshu from ( select name, sum(fenshu) as fenshu from ( select name, fenshu from tb union select nameTwo, fenshuTwo from tb union select nameThree, fenshuThree from tb union select nameFour, fenshuFour from tb union select nameFive, fenshuFive from tb ) t group by name order by sum(fenshu) ) a where rownum<6;
WITH tmp_score AS (SELECT NAME, fenshu FROM t_test_score UNION ALL SELECT nametwo, fenshutwo FROM t_test_score UNION ALL SELECT namethree, fenshuthree FROM t_test_score UNION ALL SELECT nameFour, fenshuFour FROM T_TEST_SCORE UNION ALL SELECT nameFive ,fenshuFive FROM T_TEST_SCORE) select * from( SELECT NAME, SUM(fenshu) s_score FROM tmp_score GROUP BY NAME ORDER BY s_score DESC) where rownum<=5
select name, fenshu from tb
union
select nameTwo, fenshuTwo from tb
union
select nameThree, fenshuThree from tb
union
select nameFour, fenshuFour from tb
union
select nameFive, fenshuFive from tb
order by 2, 1 )
t where rownum<6;
WITH tmp_score AS
(SELECT NAME, fenshu
FROM t_test_score
UNION ALL
SELECT nametwo, fenshutwo
FROM t_test_score
UNION ALL
SELECT namethree, fenshuthree FROM t_test_score
UNION ALL
SELECT nameFour, fenshuFour FROM T_TEST_SCORE
UNION ALL
SELECT nameFive ,fenshuFive FROM T_TEST_SCORE)
SELECT NAME, SUM(fenshu) s_score
FROM tmp_score
GROUP BY NAME
ORDER BY s_score DESC
from (
select name, sum(fenshu) as fenshu
from (
select name, fenshu from tb
union
select nameTwo, fenshuTwo from tb
union
select nameThree, fenshuThree from tb
union
select nameFour, fenshuFour from tb
union
select nameFive, fenshuFive from tb
)
t
group by name
order by fenshu ) a
where rownum<6;
from (
select name, sum(fenshu) as fenshu
from (
select name, fenshu from tb
union
select nameTwo, fenshuTwo from tb
union
select nameThree, fenshuThree from tb
union
select nameFour, fenshuFour from tb
union
select nameFive, fenshuFive from tb
)
t
group by name
order by sum(fenshu) ) a
where rownum<6;
(SELECT NAME, fenshu
FROM t_test_score
UNION ALL
SELECT nametwo, fenshutwo
FROM t_test_score
UNION ALL
SELECT namethree, fenshuthree FROM t_test_score
UNION ALL
SELECT nameFour, fenshuFour FROM T_TEST_SCORE
UNION ALL
SELECT nameFive ,fenshuFive FROM T_TEST_SCORE)
select * from(
SELECT NAME, SUM(fenshu) s_score
FROM tmp_score
GROUP BY NAME
ORDER BY s_score DESC) where rownum<=5