SELECT MAX(ROW) AS 'ROW COUNT' FROM (SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) Row FROM TEST1) A;
Asked In: Many Interviews | Alert Moderator
Login to post response