It returns Integer data type. since count function return the total count

What is the datatype returned by count(*)

Question Posted / sathishrpillai

Answer Posted / sathishrpillai

It returns Integer data type.
since count function return the total count of a particular
fields.

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the two authentication modes in sql server?

1053

How do I schedule a sql server profiler trace?

911

What is the difference between a check constraint and a rule?

1129

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1113

Can a table have 2 primary keys?

930

How to drop an existing schema in ms sql server?

1012

Do you know what is replace and stuff function in sql server?

939

How to enter binary string literals in ms sql server?

1095

How to concatenate two binary strings together?

1047

How to create a simple user defined function in ms sql server?

966

How to modify existing triggers using "alter trigger"?

933

Where are full-text indexes stored?

944

What happens if time-only values are provided as date and time literals?

952

Introduction of rollup clause using sum and group by clause?

898

Indexes are updated automatically is the full-text index also updated automatically?

973