SQL Query to find total number of rows in a table

Query to get number of rows in a table.

select count(*) from tablename

ex:select count(*) as Count from emp

Output

Count
10

SQL Server Faqs
Movie Songs Lyrics
SOftware Testing -QTP Scripts,Testing Faqs