摘要: SELECT ROW_NUMBER() OVER(ORDER BY ID ASC) AS rownum,* FROM TABLENAME;TABLENAME 为数据库表名,rownum为行号,ID为唯一标识符 阅读全文
posted @ 2011-12-21 11:13 llp074520 阅读(75) 评论(0) 推荐(0)