1) SELECT DISTINCT DEPT FROM TABLE WHERE SAL >= (SELECT MAX(SAL)

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?

Question Posted / parag

6 Answers
7184 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / parag

1) SELECT DISTINCT DEPT FROM TABLE
WHERE SAL >=
(SELECT MAX(SAL) FROM TABLE
WHERE MONTH = 'JAN');

2) SELECT DISTINCT DEPT, SAL FROM TABLE
WHERE SAL >=
(SELECT MAX(SAL) FROM TABLE);

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the differences between interval year to month and interval day to second?

963

Difference between oracle's plus (+) notation and ansi join notation?

1030

What are the database administrators utilities available?

970

Is there an oracle sql query that aggregates multiple rows into one row?

930

What is the difference between PFILE and SPFILE in Oracle?

993

How to select all columns of all rows from a table in oracle?

989

How to use fetch statement in a loop?

970

What is the disadvantage of User defind function?

2238

What are the system predefined user roles?

981

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1942

How to create a new oracle data file?

968

How to define and use table alias names in oracle?

882

Describe the types of sub query?

938

What is meant by a deadlock situation?

1047

What is an oracle database table?

958