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
Showing posts with label sql query to find number of rows in a table. Show all posts
Showing posts with label sql query to find number of rows in a table. Show all posts
Subscribe to:
Posts (Atom)