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
Explain about system stored procedure?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are the characteristics of modern DBMS?
How many replicas are maintained for each sql azure db?
What is SQL Azure?
plss anybody specify tha constrian management system in dbms
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Explain different types of locks in sql server.
How many types of the database links?
How to sort the query output with order by clauses in ms sql server?
What do you understand by user-defined function in the sql server?
How do you start single user mode in clustered installations?
‘Order by’ is not allowed in a view how can you sort information from a view?
Explain the difference between primary keys and foreign keys?
Do you know data definition language, data control language and data manipulation language?