Ho to Retrieving Table Row Count without using Count function?

Posted by vishalneeraj-24503 on 12/2/2014 | Category: Sql Server Interview questions | Views: 1689 | Points: 40

Answer:

Write below query:-

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

Bookmark It

< Previous : What is an alternative way of Retrieving Table Row ...

Next > : What will be the output of the below C# code? pro ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions