Interested to Buy Any Domain ? << Click Here >> for more details...
What is the datatype returned by count(*)
- 22 Answers
- 38034 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
Explain alternate key, candidate key and composite key in sql server?
What is db stored procedure?
What is an index. What are the types?
Explain what are various ways to enhance the ssrs report?
What is difference between oltp and olap?
Is it possible to call a stored procedure within a stored procedure?
What is factless fact table? : sql server analysis services, ssas
What are the options which must be set to allow the usage of optimistic models?
What is normalization? Explain different forms of normalization?
What is repeatable read?
What is the need for group functions in sql?
What is 1nf normalization form?
What is blocking and how would you troubleshoot it? : sql server database administration
How to provide column names in insert statements in ms sql server?
What do you mean by table and field in sql?
