SELECT MAX(A.ROW) AS 'ROW COUNT' FROM (SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) Row FROM TEST1) A; SELECT MAX(ROW) AS 'ROW COUNT' FROM (SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) Row FROM TEST1) A;
Login to post response