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 are different types of table joins?

653


Is it important for a database administrator to understand the operating system and file access?

597


Do you know what is difference between stored procedure and user defined function?

700


What is sql stored procedure?

687


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1419






Explain the difference between primary keys and foreign keys?

606


How many triggers you can have on a table?

611


How exceptions can be handled in sql server programming?

625


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

151


what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

633


can you implement data mining in SSRS?

117


Explain where clause?

626


Explain indexes disadvantages?

633


What is the difference between truncate and delete commands?

644


What do you mean by tablesample?

734