如何获得最大可见性和站名 [英] How do i get max visibility and stationname
问题描述
从AVI_02Mar2016选择A.Visibility,A.MsgDatetime,I.Stationname,I.ICAOCode在A.ICAOCode = I.ICAOCode上加入AVI_ICAOCodeList I其中I.country ='India'和
转换(datetime,'2016年3月2日11:00:00')和转换(datetime,'2016年3月2日12:00:00')之间的MsgDatetime
< b>我尝试了什么:
SELECT MAX(可见性)来自AVI_02Mar2016
WHERE可见性IN(选择A.Visibility ,A.MsgDatetime,I.Stationname,I.ICAOCode from AVI_02Mar2016 A join AVI_ICAOCodeList I on A.ICAOCode = I.ICAOCode where I.country ='India'和
MsgDatetime convert(datetime,' 2016年3月2日11:00:00')和转换(datetime,'2016年3月2日12:00:00'))
select A.Visibility,A.MsgDatetime,I.Stationname,I.ICAOCode from AVI_02Mar2016 A join AVI_ICAOCodeList I on A.ICAOCode =I.ICAOCode where I.country ='India' and
MsgDatetime between convert(datetime,'02 Mar 2016 11:00:00') and convert(datetime,'02 Mar 2016 12:00:00')
What I have tried:
SELECT MAX(Visibility) FROM AVI_02Mar2016
WHERE Visibility IN (select A.Visibility,A.MsgDatetime,I.Stationname,I.ICAOCode from AVI_02Mar2016 A join AVI_ICAOCodeList I on A.ICAOCode =I.ICAOCode where I.country ='India' and
MsgDatetime between convert(datetime,'02 Mar 2016 11:00:00') and convert(datetime,'02 Mar 2016 12:00:00'))
推荐答案
SELECT MAX(Visibility)FROM (从AVI_02Mar2016中选择不同的A.Visibility,A.MsgDatetime,I.Stationname,I.ICAOCode在A.ICAOCode = I.ICAOCode上加入AVI_ICAOCodeList I其中I.country ='India'和
转换(datetime,'2016年3月2日11:00:00')和转换(datetime,'2016年3月2日12:00:00')之间的MsgDatetime为
SELECT MAX(Visibility) FROM (select distinct A.Visibility,A.MsgDatetime,I.Stationname,I.ICAOCode from AVI_02Mar2016 A join AVI_ICAOCodeList I on A.ICAOCode =I.ICAOCode where I.country ='India' and
MsgDatetime between convert(datetime,'02 Mar 2016 11:00:00') and convert(datetime,'02 Mar 2016 12:00:00' ))as a
这篇关于如何获得最大可见性和站名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!