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
31258 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

What are the 3 types of behavioral triggers?

1314

Does view store data in sql?

1042

What view means?

1025

What is cursor explain with example?

1032

What is union?

1253

What is sql integrity?

1247

What is the difference between sql, mysql and sql server?

1176

Is json a nosql?

1035

What are analytical functions in sql?

1080

How does one load ebcdic data? : aql loader

1258

How do I remove sql developer from windows 10?

1185

What are database links used for?

1095

How to avoid duplicate records in a query?

1055

What are stored procedures in mysql?

1076

what are myisam tables? : Sql dba

1079