问mysql查询计数()限制为8

EN

select x.* from 

select case when x.count > 8 then 8 else x.count end as count, 
       x.mobile_number, 
       x.code

select if(count(a.id)>8,8,count(a.id)) as count

SELECT IF(COUNT(a.id) > 8, 8, COUNT(a.id)) AS 'count', a.mobile_number, a.shortcode AS 'code'
FROM tbl_votes AS a 
INNER JOIN tbl_members AS b ON b.mobile_number = a.mobile_number 
WHERE a.possition_id = 3 
GROUP BY a.mobile_number;

SELECT t.id, t.mobile_number, t.shortcode AS 'code' 
FROM (SELECT t.id, t.mobile_number, t.shortcode,
               CASE 
                 WHEN @category != t.mobile_number THEN @rownum := 1 
                 ELSE @rownum := @rownum + 1 
               END AS rank,
               @category := t.mobile_number AS var_category
          FROM tbl_votes t
          JOIN tbl_members AS b ON b.mobile_number = t.mobile_number 
          JOIN (SELECT @rownum := NULL, @category := '') r     
      ORDER BY t.mobile_number,t.id DESC) X
      WHERE x.rank<=8;