How to display Row count in a Select Query in Sql Server?

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

Answer:

Write below query:-

select *,(select count(1) as row_count from test1) Row_Count from test1;

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to retrieve the Number of Rows in a Gridview t ...

Next > : How to get an HTML table rows count when it contai ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions