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

Can we use ddl commands in pl sql?

0 Answers  

What are different methods to trace the pl/sql code?

0 Answers  

Why is theta join required?

0 Answers  

What does “select count(1) from tab” result?

10 Answers   IBM,

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

Explain the select statement in sql?

0 Answers  

What is the use of sqlerrd 3?

0 Answers  

What is the use of stored procedures?

0 Answers  

Explain the difference between drop and truncate commands in sql?

0 Answers  

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

What is server name sql?

0 Answers  

Explain the concept of normalization.

3 Answers