SQL查询航班信息:实际航行时间、航线、按计划起飞时间排序
SELECT CONCAT(airlines_cd,fit_no) AS flight_no, TIMEDIFF(fit_act_tm,fit_sch_tm) AS actual_flight_time, airline_fullname AS route FROM f_flight_info WHERE fit_act_tm >= '2022-01-01' AND fit_act_tm <= '2022-01-03' ORDER BY fit_sch_tm DESC
原文地址: https://www.cveoy.top/t/topic/pEEE 著作权归作者所有。请勿转载和采集!