mysql查询结果去重

发布时间:2024-04-09 08:01

select * from (select * from t_stb_log where 1=1 and hotelid =355  order by (UNIX_TIMESTAMP(lastonlinetime)-UNIX_TIMESTAMP(logintime))/60  desc ) a group by a.stbnum order by lastonlinetime

ItVuer - 免责声明 - 关于我们 - 联系我们

本网站信息来源于互联网,如有侵权请联系:561261067@qq.com

桂ICP备16001015号