sql 查询时加行号

select ROW_NUMBER()Over(ORDER BY UserID)  as rowId,UserID,UserName from  Users

posted @ 2011-04-26 22:01  lenya  阅读(141)  评论(0)    收藏  举报