consider a table which contain 4 columns,ename,eno,sal and deptno, from this t

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 / rajeshwari bahaddur

24 Answers
24170 Views
Mind Tree, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ..

Answer / sonal

select * from (select ename, deptno,sal
from emp where deptno in(10 , 20)
order by sal desc)
where rownum < =1

Is This Answer Correct ?

2 Yes

4 No

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ..

Answer / partha

Select emplid, sal from (select emplid, sal from
emp_sal_tbl where deptid = 10 order by sal desc) a where
rownum < 2
union
Select emplid, sal from (select emplid, sal from
emp_sal_tbl where deptid = 20 order by sal desc) a where
rownum < 2

Is This Answer Correct ?

0 Yes

4 No

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ..

Answer / sumesh s.g

select Name from TBL_Employee
where Salary in(
select max(Salary) from dbo.TBL_Employee
group by DepID
having DepID in(10,20))

--Happy Codding--

Is This Answer Correct ?

0 Yes

5 No

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ..

Answer / nancy

Select ename from table where dept_no in ('10','20') group
by dpt_no

Is This Answer Correct ?

4 Yes

27 No

Post New Answer