sqlserver2005实现oracle中的rownum功能
2007-06-11 14:46
select ROW_NUMBER() OVER (ORDER BY UpdateDate desc) AS rowNum,* from ocs_replyTasks ROW_NUMBER
返回类型: |
select ROW_NUMBER() OVER (ORDER BY UpdateDate desc) AS rowNum,* from ocs_replyTasks ROW_NUMBER
返回类型: |
转载于:https://www.cnblogs.com/shuaifeng/archive/2009/08/08/1541840.html