mysql如何使用分组排序 sql怎么分组排序

文章摘要：mysql如何使用分组排序 sql怎么分组排序

mysql中使用分组排序的方法 在mysql中使用order by方法实现分组排序 实现方法如下： selec […]

mysql中使用分组排序的方法

在mysql中使用order 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;