snrtuemc 回复 yzm742603(提问者)既然只要一条,最后的group by F_KSRQ不需要了,要不要in,直接=就可以,select * from (SELECT distinct F_HD,F_FLIGHTAIRLINENO, F_KSRQ, F_DISTANCE, F_DRBZ FROM GG_ZDHLF_HXK
WHERE 1=1 and F_HD=\'HGH-CTU\'
ORDER BY F_HD,F_KSRQ DESC,F_FLIGHTAIRLINENO ) t where F_KSRQ = (select max(F_KSRQ) from GG_ZDHLF_HXK )
snrtuemc 回复 yzm742603(提问者)那就又要嵌套一层了,select * from (SELECT distinct F_HD,F_FLIGHTAIRLINENO, F_KSRQ, F_DISTANCE, F_DRBZ FROM GG_ZDHLF_HXK WHERE 1=1 and F_HD=\\\'HGH-CTU\\\' ORDER BY F_HD,F_KSRQ DESC,F_FLIGHTAIRLINENO ) t where F_KSRQ in (select F_KSRQ from (select F_HD,max(F_KSRQ) as F_KSRQ from GG_ZDHLF_HXK group by F_HD ))