1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES;
2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES;
ouput should be in table format
Answer Posted / aparna sanas
true Output will come in table format in single row and single
column
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
What is use of @@ spid in sql server?
What is the difference RDBMS and Graph Database?
What is a domain constraint give an example?
What are the steps you must follow to hide sql server instances?
what are the different types of replication you can set up in sql server? : Sql server database administration
how to determine the service pack currently installed on sql server? : Sql server database administration
What are four major operators that can be used to combine conditions on a where clause?
How to end a stored procedure properly in ms sql server?
Give a example to search fr a string in all stored procedure in sql server.
Explain what is the purpose of sql profiler in sql server?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How to create a user name in a database?
What is difference between standardization and normalization?
Can you explain what is the use of custom fields in report?
write an SQL query to list the employees who joined in the month of January?