这样的Sql怎么写?
Select StationNum,ObservationTime,ExMaxWindDirection,ExMaxWindSpeed From tabgeneraldata where ObservationTime between '20070801200000 'and '20070802110000 ' order by ObservationTime
查询得表如下:
StationNum ObservationTime ExMaxWindDirection ExMaxWindSpeed
---------- --------------- ------------------ --------------
M1901 20070801200000 257 008
M1901 20070801210000 006 ///
M1901 20070801220000 307 013
M1901 20070801230000 310 010
M1901 20070802000000 284 006
M1901 20070802010000 248 010
M1901 20070802020000 278 008
M1901 20070802030000 314 005
M1901 20070802040000 239 009
M1901 20070802050000 251 010
M1901 20070802060000 241 009
M1901 20070802070000 259 012
M1901 20070802080000 280 010
M1901 20070802090000 248 008
M1901 20070802100000 227 008
M1901 2