SQL Sum函数限制0,3返回整个列的和

下午好，

我正在寻找在以下查询中总列的总和:

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 );

1235 -这个版本的MySQL还不支持'LIMIT &//任何/所有子查询的

我怎样才能得到这三条记录的总和?