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
What is 1nf 2nf?
How do I make a resultset scrollable?
What is normalization? What number of normalization shapes are there?
How to link tables in sql server?
What is transaction server distributed transaction?
How do I view a stored procedure in sql server query?
What is a not null constraint?
What are indexes in sql?
What is database white box testing?
Is it safe to delete log files?
How to remove duplicate rows from table except one?
Explain the flow of creating a cube? : sql server analysis services, ssas
Who is the owner of a schema in ms sql server?
How many types of triggers in sql server?
Explain about system stored procedure?