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 merge join?
Can we join two tables without primary key?
What is the purpose of indexing?
Comment,Datatypes are unlimited
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
How do I view a stored procedure in sql server query?
How do I find the query plan in sql server?
What is the difference between a function and a trigger?
Explain few examples of RDBMS?
Why union all is faster than union?
Is it possible to replicate data from sql server to oracle? : sql server replication
How many types of keys are there?
What is difference between unique and primary key?
how to trace the traffic hitting a sql server? : Sql server database administration
What is molap and its advantage? : sql server analysis services, ssas