ZhangYuesong0923的博客

select * from (select top 5 * from (select top (5*1) * from md_dr_service_station order by md_id asc ) as s order by md_id desc ) ss order by md_id asc 5是一页显示几条数据，1是第一页 ...

"select * from(" + " select *, ROW_NUMBER() OVER(order by t1.md_user_id desc) as Row from " + " (select md_usertab.*,md_dr_service_station.md_service_name from md_usertab inner join md_dr_service_sta...