What is the datatype returned by count(*)

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db stored procedure?

471


What is the Main Difference between ACCESS and SQL SERVER?

563


explain different types of joins? : Sql server database administration

534


Explain few of the new features of sql server 2008 management studio

526


In which tcp/ip port does sql server run? Can it be changed?

550






What do you mean by cardinality?

497


What is an index in sql?

555


Sql server reporting services vs. Crystal reports.

96


Is a primary key unique?

542


What are the different acid properties?

629


What is the difference between system objects and user objects?

711


How many database files are there in sql server 2000?what are they?

583


what are the different stages of Report Processing?

97


What is the difference between substr and charindex in the sql server?

512


which table keeps the locking information? : Sql server administration

526