sql server数据行号 

select ROW_NUMBER() over(order by createTime desc) as RowNum,NoticeContent,CreateTime from PTS_NoticeConfig

 

posted @ 2014-05-12 11:19  kedarui  阅读(203)  评论(0)  编辑  收藏  举报