Answer / avinash

select ename from emp where sal in(select max(sal) from
emp) and deptno in(10,20)

Answer / sanjeev

SELECT ENAME FROM TABLE NAME WHERE SAL>(SELECT MAX(SAL)
FROM TABLE NAME GROUP BY DEPTNO

Answer / praveen reddy.eddula

select ename from emp where sal in(select max(sal) from emp
where deptno in(10,20))

Answer / swati pise

select top 1 * from table where dept_no in(10,20) order by
sal desc

Answer / swati

select top 1 ename from emp where deptno in(10,20) order by
sal desc

Answer / lipika

Select Ename From emp where sal in (Select Max(Sal) From
emp where deptno in (10,20) group by deptno);

Answer / john

select dept_id,ename max(sal) from employee where dept_id
in ('1','2') group by dept_id;

Answer / pratdeor

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

Answer / gautam

select ename,sal from emp
where sal in (select max(sal) from emp group by deptno)
and deptno in (10,20)

Gautam

Answer / sp

select top 2 ename, salary, dept from dbo.employee where
dept in(10,20) order by salary desc

How to call the function and Procedure in trigger?

3 Answers   IBM,

Where can I learn sql for free?

0 Answers  

Can ddl statements be used in pl/sql?

0 Answers  

How long will it take to learn pl sql?

0 Answers  

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

What is the least restrictive isolation level? : Transact sql

0 Answers  

What do you mean by field in sql?

0 Answers  

What is acid property in a database?

0 Answers  

what are the limitations of identity column? : Transact sql

0 Answers  

What is sql*loader and what is it used for?

0 Answers  

What is rowtype?

0 Answers  

What are the components of a PL/SQL block ?

3 Answers