一条SQL语句实现数据库分页

一种:

select * from (

select top 20 * from(

select top 80 * from( 
select a.* from business.dbo.tb_cocacola_mms as a 

where a.checkTag=1 
)

as x order by x.updateTime desc)

as y order by y.updateTime asc)

as z order by z.updateTime desc