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

Explain steps of normalization?

719

How can a user-defined datatype be created?

730

What do you understand by user-defined function in the sql server?

697

How to find which stored procedure is currently running in sql server?

669

How to use go command in "sqlcmd"?

851

tell me the disaster recovery plan

2191

What is an indexing strategy?

705

Explain what role entity and relationship play in an ER diagram.

789

What is database white box testing?

840

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

752

How to automatically create a log when an exception is being received into SQL Server?

928

do you know how to configure db2 side of the application? : Sql server database administration

783

What is query parameter in ssrs?

132

What are the different SQL Server Versions you have worked on?

764

What is difference between createstatement and preparedstatement?

790