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
29543 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 is coalesce sql?

943

What is transaction control language (tcl)?

1073

Explain the difference in execution of triggers and stored procedures?

969

Is left join same as inner join?

1023

What is package in pl sql with an examples?

972

How do you drop a trigger?

924

What is query syntax?

915

What are different clauses used in sql?

1077

what is the difference between union and union all? : Sql dba

976

Which is better stored procedure or query?

922

how to decrement dates by 1 in mysql? : Sql dba

970

What are the different types of database management systems?

951

How is data stored in sql?

1005

How do you run a query?

958

Which query operators in sql is used for pattern matching?

904