Question

关于Sql语句 嵌套查询

请问
select * from(
select * , row_number() over(partition by StationNum order by MaxTemp desc) as rowNum
from (
Select StationNum,MaxTemp , timemaxTemp
from tabRealTimeData
Where ObservTimes between '2013050721' and '2013050820'
)as MyDataSet
) b
where rowNum =1

这是取日最高气温和出现时间的语句，用了三层嵌套，有没有大侠能帮我改简单点呢？

其中StationNum：站点 MaxTemp：定时的最高温度 timemaxTemp 最高温度出现时间
tabRealTimeData：表名 ObservTimes：观测时间

Answer 1

select * from(
Select StationNum,MaxTemp , timemaxTemp ,row_number() over(partition by StationNum order by MaxTemp desc) as rowNum

from tabRealTimeData
Where ObservTimes between '2013050721' and '2013050820'
) b
where rowNum =1

--中间的一层可以去掉