use master
go
create database test
Go
创建数据库
SELECT C.stationnumber, C.RecordDimension, C.RecordLongitude, C.RecordDateTime, C.RecordOther, C.note
FROM (SELECT *
FROM (SELECT Row_Number() OVER (ORDER BY RecordDateTime DESC) AS jd, *
FROM RealTimeRecord) AS A
WHERE A.jd >= 1 AND A.jd <= 20000 AND A.StationNumber = 1120040010) AS C INNER JOIN
StationInfor ON StationInfor.id = C.StationId
分页联合查询
SELECT *
FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY a.recorddatetime DESC) AS RowNumber
FROM realtimerecord AS a) AS b
WHERE RowNumber BETWEEN 1 AND 5
单表分页查询
SELECT *
FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY a.recorddatetime DESC) AS RowNumber
FROM realtimerecord AS a) AS b INNER JOIN
StationInfor ON StationInfor.id = b.StationId
WHERE RowNumber BETWEEN 1 AND 100000