关于Sql语句嵌套查询

11 |

1 | 2013-5-9 14:46:54 | 显示全部楼层 |阅读模式

select * from(Select StationNum,MaxTemp , timemaxTemp ,row_number() over(partition by StationNum order by MaxTemp desc) as rowNum from tabRealTimeDataWhere ObservTimes between '2013050721' and '2013050820' ) bwhere rowNum =1--中间的一层可以去掉...

使用道具举报