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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suman rana
select dept from ( select dept,
max(sal) over() maxsal,
sal from ( select dept,
max(sal) sal
from E
where month=JAN'
group by dept
)
) WHERE maxsal = sal;
select distinct dept from ( select dept, max(sal) over ()
maxsal, sal
from E
)
where maxsal = sal;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Answer / shilpa
1) select dept , max(sal) from E where month=JAN';
2) select dept , max(sal) from E ;
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / mayur
select max(sal) from e where sal in (select month form e
where month = 'JAN';
Is This Answer Correct ? | 0 Yes | 5 No |
how to find find & delete duplicate rows from two different tables?
What is Index Cluster ?
What is mean by Program Global Area (PGA) ?
what are pseudocolumns?
Explain what are clusters?
How to enter a new row into a table interactively?
Can a formula column be obtained through a select statement ?
What are the types of Database Links ?
How do we know whether an index is created on a table ???
What is oracle database 10g express edition?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How does Oracle guarantee data integrity of data changes?