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
Do you know the capabilities of cursors?
What is the recommended total size of your memory optimized tables?
How can you manage sql azure security?
Explain the dirty pages?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is report subscription?
How do I manually uninstall an instance of sql server 2016?
How do you run a trace?
how you can configure a running aggregate in SSRS?
How we can compare two database data?
What is the difference between varchar and nvarchar?
What are the restrictions that views have to follow?
How to specify the collation for a character data type in ms sql server?
what are different types of backups available in sql server? : Sql server database administration
What is difference between aggregate and analytic function?