sql server 2005+ 翻页

select * from 
( 
 select row_number() over (order by dm) row,* from t_zycp where dm like '%4%' 
) tmp where row between 1 and 10