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

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

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

0 Answers  

What is the use of time stamp in select statement?

1 Answers   TCS,

What is sql mysql pl sql oracle?

0 Answers  

What is assignment operator in pl sql?

0 Answers  

Is join an inner join?

0 Answers  

is mysql query is case sensitive? : Sql dba

0 Answers  

How do I view tables in sql developer?

0 Answers  

What are the most important characteristics of pl/sql?

0 Answers  

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

What is the difference between an inner join and an outer join?

0 Answers  

Is join same as left join?

0 Answers