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 / venkateswara reddy
1)select dept from E where sal=(select max(sal) from E where
month='JAN')
2)select dept from E where sal=(select max(sal) from E)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to check the oracle tns settings?
What are the logical operations?
Differentiate between function and procedure in oracle.
How many data types are supported?
Is oracle an open source?
Can we create database in oracle using command line ?
How to do paging with oracle?
Give the constructs of a package, function or a procedure.
What is a connect identifier?
what is port in oracle? how is it related to database application.
List the parts of a database trigger.
How to rollback the current transaction in oracle?
What happens to the current transaction if the session is ended?
How to convert raw data type into text in oracle? Explain
Explain an exception?