What is the datatype returned by count(*)
- 22 Answers
- 34763 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
What do you understand by recursive stored procedure?
Explain mixed authentication mode of sql server?
What encryption security is available in sql azure?
What do you understand by check constraint in sql server?
Which tools are available to manage SQL Azure databases and servers?
How exceptions can be handled in sql server programming?
what do you understand by change data capture?
How to replace given values with null using nullif()?
Difference between connected and disconnected database in .net with sql server?
What is the difference function and stored procedure?
What does it mean to be in union?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is the difference between upgrade and migration in sql server?
Explain following error properties?
What are the five characteristics of good data?
