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 / mayur
select max(sal) from e where sal in (select month form e
where month = 'JAN';
Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
When do you get a .pll extension in oracle?
What is oracle datasource?
How to use "for" statements in oracle?
Is rowid unique in oracle?
How to convert character types to numeric types?
How to start instance with a minimal initialization parameter file?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is an oracle user account?
Explain self joins in oracle?
What is a relational database management system?
How to export data with a field delimiter?
What is a cursor variable?
What is an oracle transaction?
how to join query for one source type is oracle another source type is sql server ?
What is user managed backup in Oracle?