Select ename from table where sal IN (select Max(sal) over (partition by D

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.

Question Posted / pratdeor

24 Answers
30487 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / pratdeor

Select ename from table where sal IN
(select Max(sal) over (partition by Deptno) as mxs from table) and Deptno IN (10,20);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of cursors are available in pl/sql?

1111

What is trigger in flip flop?

1007

What is view explain with example?

935

Is natural join and inner join same?

930

What is the difference between distinct and unique in sql?

952

What is varchar sql?

1150

What is the sql case statement?

1011

What is string join?

981

What is compilation error in pl sql?

984

Can there be more than one function with a similar name in a pl/sql block?

985

What are all ddl commands?

1086

What is sql lookup?

924

What are joins in sql?

1048

What are the different types of dbms?

1016

Why is stored procedure faster than query?

963