count(*) returns the total number of not null values in given column

What is the datatype returned by count(*)

Question Posted / thirumal

Answer Posted / thirumal

count(*) returns the total number of not null values in
given column

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How will you find out if there are expensive SQL statements running or not?

1010

Can you leave a union at any time?

1057

Where the sql logs gets stored?

982

How each E-R model constructs can be mapped to the relational model?

998

How do you troubleshoot errors in a SQL Server Agent Job?

1055

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

963

Can we write a distributed query and get some data which is located on other server and oracle database?

1225

What is auditing in sql server?

920

What is recompile sql server?

1033

Give an example of why you would want to denormalize a database

974

How to execute stored procedure and set temp table in sql server?

1034

What Is Rdbms?

1151

How many servers can we create in a single subscription?

162

What programming language would you use to create embedded functions in ssrs?

184

Can group functions be used in the order by clause in ms sql server?

1013