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 is shared lock?

947

Why de-normalization required?

1053

Is a primary key unique?

1035

How sql server enhances scalability of the database system?

1315

How to insert a new row into a table with "insert into" statements in ms sql server?

1013

What it means to be triggered?

1081

In how many ways you can invoke ssrs reports?

147

What is importing utility?

1038

What is the full form of ddl?

965

Explain how you can deploy an SSRS report?

156

Working with TLogs

1895

What are basics of policy management?

1150

What is a collation in ms sql server?

1132

Why should you use or avoid select * statements?

1071

What structure can you implement for the database to speed up table reads?

1234