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

Write down the syntax and an example for create, rename and delete index?

982

How to rename databases in ms sql server?

1201

Tell me about normalization in DBMS.

995

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

985

Difference between DELETE and TRUNCATE?

1047

What is clustered index

1007

What is transaction server auto commit?

1060

What is the purpose of forms?

958

What is the osql utility?

962

How many ways to create table-valued functions?

983

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

950

What is the language structure to add a record to a table?

1025

What is the difference between stored procedure and functions?

1133

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2069

what are constraints? Explain different types of constraints? : Sql server database administration

984