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

application server is slow what may be the problem

2210

Where in ms sql server is ’100’ equal to ‘0’?

1074

What do you understand by integration services in sql server?

955

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

934

What is the difference between a local and a global temporary table?

1106

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1200

Explain about thread and memory management process of SQL?

963

When would you use the stored procedures or functions?

998

Explain indexing and what are the advantages of it?

1012

What is inner join in sql server joins?

1023

How to filter out duplications in the returning rows in ms sql server?

1124

What are the differences between union, intersect, and minus operators?

1078

What is difference between view and materialized view?

927

How do I find the query plan in sql server?

944

How to delete database objects with "drop" statements in ms sql server?

1076