SQL每日一题(20221011)
select tripsid,
adddate(min(settime),1)settime1,
adddate(max(settime),1)settime2
from t0707
group by tripsid;
SQL每日一题(20221011)
select tripsid,
adddate(min(settime),1)settime1,
adddate(max(settime),1)settime2
from t0707
group by tripsid;