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
向下取整 |
|
向上取整 |
|
四舍五入 |
|