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
How to write an inner join with the where clause in ms sql server?
How to execute function in stored procedure sql server?
What is the difference between function and stored procedure in sql server?
What are commit and rollback in sql?
What is 1nf 2nf and 3nf?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What gets stored inside msdb database?
What is sql server database?
what is sql server? : Sql server database administration
What are different types of statement?
how to create “alternate row colour”?
How to create a store procedure with encryption?
What is raid, and how it can influence database performance?