下午好,
我希望在下面的查询中找到total列的总和:
SELECT *
FROM `btb_picks`
WHERE `player_name` = 'bryan'
ORDER BY `total`
LIMIT 0 , 3该表共有9条记录,其中player_name='bryan‘
Position Golfer Name Round 1 Round 2 Round 3 Round 4 Today Through Total Player Name
T4 Lee Westwood 67 12:25 - - -5 F -5 bryan
T4 Justin Rose 67 1:39 - - -5 F -5 bryan
T4 Sergio Garcia 67 1:49 - - -5 F -5 bryan我想收集这3条记录的总和(-15
当我运行以下查询时:
SELECT SUM( total ) AS 3_man
FROM `btb_picks`
WHERE `player_name` = 'bryan'
ORDER BY total
LIMIT 0 , 3它返回:
3_man -13
它是整个总数列的总和,而不是我想要求总数的3条记录的总和。
当我以这种方式尝试查询时:
SELECT * FROM `btb_picks` WHERE `player_name` in ( SELECT *
FROM `btb_picks`
WHERE `player_name` = 'bryan'
ORDER BY `total`
LIMIT 0 , 3 );SQL的叫声:
1235 -此版本的MySQL尚不支持'LIMIT &IN/ALL/ANY/SOUN子查询‘
我怎样才能得到这三条记录的总和?
发布于 2014-05-09 14:45:23
试试这个。
SELECT SUM(s.score) FROM
(SELECT total as score FROM btb_picks WHERE player_name = 'bryan' ORDER BY total LIMIT 0,3) shttps://stackoverflow.com/questions/23558162
复制相似问题