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

what are defaults? : Sql server database administration

1069

What is SQL Azure Data sync?

119

Do you know the isolation level that sql server support?

948

What is the dbcc command and why is it used?

1033

Can you please differentiate between a primary key and a unique key?

993

What are the properties and different types of sub-queries?

991

How do database indexes work?

993

What are the difference between primary key and unique key? : sql server database administration

922

When multiple after triggers are attached to sql table, how to control the order of execution?

1026

What are sql azure firewall rules?

106

Explain a join?

1047

What are types of scd? : sql server analysis services, ssas

998

What is a bit datatype?

963

What is the difference between join and inner join?

997

What are the different types of sql server replication? : sql server replication

1240