row_number() over()
over(可以填排序方式,过滤的方式)
select *
from (select t.*,
row_number() over(order by sectionid, tollstationid, tollplazaid, tolllaneid) as row1
from tview_tech_lanedevice t)
where row1 between 0 and 10
over(可以填排序方式,过滤的方式)
select *
from (select t.*,
row_number() over(order by sectionid, tollstationid, tollplazaid, tolllaneid) as row1
from tview_tech_lanedevice t)
where row1 between 0 and 10