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
29827 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 can we link a sql database to an existing android app?

1002

How many sql commands are there?

1086

What is constant in pl sql?

995

How is a PL/SQL code compiled?

1183

What is the current version of postgresql?

1028

Are sql database names case sensitive?

958

How do you bind variables in pl sql?

1055

What is the difference between database trigger and stored procedure?

1034

What do you understand by case manipulation functions?

985

what is log shipping? : Sql dba

1079

what is a composite primary key ? : Sql dba

1017

Is pl sql still used?

946

What is varchar example?

992

What is difference between mysql and postgresql?

1080

What is write ahead logging in sql server?

1012