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

how many triggers you can have on a table? : Sql server database administration

924

What is amo? : sql server analysis services, ssas

1052

How can I get data from a database on another server?

939

What are logical/boolean operations in ms sql server?

989

If user is owning any SQL Objects, can we drop that user

2019

What is a user-defined function in the sql server and what is its advantage?

1050

What is a deadlock and what is a live lock?

959

How adventureworkslt tables are related?

889

What are commonly used odbc functions in php?

982

Define compound operators?

870

What is dbcc?

1090

Explain what are the events recorded in a transaction log?

945

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

116

Explain what you mean by 3 tier architecture.

1024

What is serializable?

1001