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'))