Interested to Buy Any Domain ? << Click Here >> for more details...
What is the datatype returned by count(*)
- 22 Answers
- 39683 Views
- 247Customer, Asian CERC, I also Faced
- E-Mail Answers
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
How the authentication mode can be changed?
Where are full-text indexes stored?
Name and describe few console utilities for ssrs?
What is rtm version in sql server?
How use inner join in sql server?
How to download and install the scaled-down database adventureworkslt?
Explain the different types of backups available in sql server? : sql server database administration
How to insert stored procedure result into temporary table?
How to create new tables with "create table" statements in ms sql server?
How to create nested stored procedure?
What is table level trigger?
What is a print index?
What is the difference between an index and a unique index?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Difference between primary key and clustered index?
