sql SELECT 增加行号

    法1:SELECT  ID ,
            rownumb = ROW_NUMBER() OVER ( ORDER BY ID DESC )
    FROM    dbo.AM_Project P
    WHERE   IsDel = 1;

   法2: SELECT  ROW_NUMBER() OVER ( ORDER BY ID DESC ) AS rownum,     *
    FROM    dbo.AM_Project P
    WHERE   IsDel = 1;
 

   法3: DROP TABLE #temptable;

    SELECT  IDENTITY( INT, 1,1 ) AS 行号 ,  *
    INTO    #temptable
    FROM    dbo.AM_Project P
    WHERE   IsDel = 1;
                  
    SELECT  *
    FROM    #temptable;