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 command is used to delete a table from the database in the sql server and how?

1183

When multiple after triggers are attached to sql table, how to control the order of execution?

1100

Explain the etl (extraction, transformation, and loading)?

1048

What happens if null values are involved in datetime operations?

1021

What is truncate table?

997

How many primary keys are possible in a table?

962

how would you troubleshoot blocking? : Sql server database administration

1022

What is the use of sql profiler in sql server 2012?

941

What is a linked server in sql server?

1129

Mention the differences between substr and charindex in sql server.

1108

what is the information that can be stored inside a bit column? : Sql server database administration

1008

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

1080

What are data driven subscriptions?

115

How to see existing views in ms sql server?

1105

In what three ways is the return statement used in a stored procedure?

1060