2012年9月7日
sql 分页加排序等写法
摘要： select * from (select ROW_NUMBER() over(order by _order desc) as _PID, * From (select (ID+PID) as _order ,* from Menu) as __SubQuery)as _SubQuerywhere _PID between 12 and 20order by _order desc 阅读全文
posted @ 2012-09-07 21:19 Shikyoh 阅读(387) 评论(0) 推荐(0) 编辑