select count(*) from table_name will hold good if there isn't any WHER

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

Question Posted / anand

Answer Posted / anand

select count(*) from table_name will hold good if there isn't any WHERE clause in it as it is a AGGREGATE Function.. (just additional information)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain can SSRS reports Cache results?

149

How to create percentile function?

139

Can you pass expressions to stored procedure parameters?

972

how can you attach more than 20 ldf files in sql server

1949

Who is the owner of a schema in ms sql server?

1011

Can we return Data from 4(more than 1) tables in stored procedure?

1007

What is the difference between index seek vs. Index scan?

974

How to download and install the scaled-down database adventureworkslt?

954

What is failover clustering overview?

1023

What is meant by Active-Passive and Active-Active clustering setup?

1069

Do you know what is lock escalation?

964

Other than truncate statement, which other command can by-pass the trigger on the tables?

1069

Will count(column) include columns with null values in its count?

1035

What is page in sql server?

901

What does this statement do @@rowcount?

927