Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the datatype returned by count(*)

Answer Posted / harsh

SELECT COUNT(*) as "Number of employees"
FROM employees
WHERE salary > 55000;

It would return the following result set:
Number of employees
5
HENCE IT RETURNS 'INT' TYPE.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is 1nf 2nf?

1016


How do I make a resultset scrollable?

966


What is normalization? What number of normalization shapes are there?

1115


How to link tables in sql server?

941


What is transaction server distributed transaction?

1065


How do I view a stored procedure in sql server query?

936


What is a not null constraint?

1040


What are indexes in sql?

1289


What is database white box testing?

1131


Is it safe to delete log files?

929


How to remove duplicate rows from table except one?

1016


Explain the flow of creating a cube? : sql server analysis services, ssas

1061


Who is the owner of a schema in ms sql server?

1081


How many types of triggers in sql server?

1039


Explain about system stored procedure?

1041