the question is how do find number of rows in a table? select count(*) f

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

Question Posted / raghuram

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

Please Help Members By Posting Answers For Below Questions

Do you know sql server 2008 introduces automatic auditing?

901

Does sql server 2000 clustering support load balancing?

903

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1264

What are translations and its use? : sql server analysis services, ssas

992

How to create a store procedure with encryption?

949

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

923

what is the information that can be stored inside a bit column? : Sql server database administration

901

Explain where clause?

931

what are database files and filegroups? : Sql server database administration

883

Explain the truncate command? : SQL Server Architecture

1091

How to insert stored procedure result into temporary table?

977

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1010

mention different types of relationships in the dbms?

962

Is the log file is a part of file group?

974

Difference between report and query parameter.

1022