select
user_id,
sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) as point
from
visit_tb
group by
user_id
order by
point desc
向下取整 |
|
向上取整 |
|
四舍五入 |
|

select
user_id,
sum(floor(timestampdiff(minute,visit_time,leave_time)/10)) as point
from
visit_tb
group by
user_id
order by
point desc
向下取整 |
|
向上取整 |
|
四舍五入 |
|