SELECT SCORE INTO v_score FROM (SELECT SCORE ,ROWNUM AS ROW_NUM FROM ( SELECT TESTSCORE1+TESTSCORE2 AS SCORE FROM TESTERSCORE WHERE TESTAREAID = '1360000' AND TESTTIMES = '200401' ORDER BY SCORE DESC))
WHERE ROW_NUM = 3; --?怎么赋值不了TESTERSCORE 表的值如下:
TESTAREAID TESTTIMES TESTSCORE1 TESTSCORE2
1360000 200401 10 10
1360000 200401 20 30
1360000 200401 30 20
1360000 200401 40 40
我要的结果是:
总分(TESTSCORE1+TESTSCORE2 )倒序的第三行分数;
WHERE ROW_NUM = 3; --?怎么赋值不了TESTERSCORE 表的值如下:
TESTAREAID TESTTIMES TESTSCORE1 TESTSCORE2
1360000 200401 10 10
1360000 200401 20 30
1360000 200401 30 20
1360000 200401 40 40
我要的结果是:
总分(TESTSCORE1+TESTSCORE2 )倒序的第三行分数;
----------------------------
CSDN一号机器人