题解 | 查询连续入住多晚的客户信息？
查询连续入住多晚的客户信息？
https://www.nowcoder.com/practice/5b4018c47dfd401d87a5afb5ebf35dfd
# datediff：取得两个日期之前的差值 select user_id, c.room_id, room_type, datediff(checkout_time,checkin_time) days from checkin_tb c left join guestroom_tb g on c.room_id = g.room_id where datediff(checkin_time,'2022-06-12') >= 0 and datediff(checkout_time,checkin_time) >1 order by days,room_id,user_id desc
OPPO公司福利 1225人发布