How do you find the number of rows in a table?

Answer Posted / raghuram

the question is how do find number of rows in a table?

select count(*) from table_name

by using this we will get exact number of rows in a table.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the exact numeric data type in sql?

551


What is difference between temp table and cte?

542


How to throw custom exception in Stored Procedure?

584


How is a full-text index updated?

545


How do I delete a sql server database?

551






What is cursor in ms sql server?

570


Explain the microsoft sql server delete command? : SQL Server Architecture

587


What is implicit mode in sql server?

567


What new changes are being made in SQL Server?

578


What is set nocount on and what is set nocount off?

517


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

703


What are the 3 types of schema?

604


How can delete duplicate records in cte in sql server?

524


What are the instances when triggers are appropriate?

528


How do you handle datasets larger than 50 gb?

140