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
mysql查询结果去重
最新推荐文章于 2024-04-19 22:58:09 发布