Table E:
Name dept month sal
1 A JAN 800
2 B APR 1000
3 A JAN 300
4 A JAN 600
5 C JUN 400
1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH?
2) WRITE QUERY GET MAX SAL DEPT NO?
Answer Posted / shilpa
1) select dept , max(sal) from E where month=JAN';
2) select dept , max(sal) from E ;
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
 What are the oracle DML commands possible through an update strategy?
What is a synonym? What are its various types?
How to increment dates by 1 in oracle?
What is the database name in oracle?
How to install oracle odbc drivers?
State and explain about oracle instance?
How to define a variable of a specific record type?
How many types of table in Oracle?
Explain the difference between replace() and translate() functions in oracle?
What is bulk collect in oracle?
What is a user account in oracle?
How to bring a tablespace offline?
What is an oracle database table?
What do you mean by group by clause?
what happened to the global index when I truncate the data in one of the partition?