Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 7630 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
Explain the use of control file?
What is the exact use of Collections?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What privilege is needed for a user to create views in oracle?
How much memory your 10g xe server is using?
Differentiate between pre-select and pre-query?
How to connect to a remote server?
Is java required for oracle client?
How do we create privileges in oracle?
What is a user role in oracle?
Explain database link?
How to specify default values in insert statement using oracle?
What is the maximum number of triggers that can be applied to a single table?
What is a sub query? What are its various types?
How to write date and time interval literals in oracle?
