sqlserver2005实现oracle中的rownum功能
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
返回类型: |