09 2012 档案

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 阅读(398) 评论(0) 推荐(0)