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 the starting oracle error number?

0 Answers  

What is the sql query to display the current date?

0 Answers  

What does partition by mean in sql?

0 Answers  

Does execute immediate commit?

0 Answers  

What is pls integer?

0 Answers  

What is rtm stands for?

0 Answers  

what is sql profiler? : Sql dba

0 Answers  

What is the best partition size for windows 10?

0 Answers  

What is cursor status?

0 Answers  

How do you modify a table in sql?

0 Answers  

Does inner join return duplicate rows?

0 Answers  

What is a transaction?

5 Answers