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