Mysql利用group by分组排序

select id, (@rowno := @rowno + 1) as rank, score, (C.end_time - C.start_time) as timeConsuming, start_time, real_name, tel, expiry_code from (SELECT *  FROM (select *   from t_q_order B   where B.score > 0   and B.tel IS NOT NULL   order by B.score desc,    (B.end_time - B.start_time) asc,    B.start_time asc) as A  group by A.tel  ORDER BY A.score desc,   (A.end_time - A.start_time) asc,   A.start_time asc)  as C, (select @rowno := 0) t where (C.end_time - C.start_time) > 5 limit 0,50;