Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Delete the emps whose salaries are lowest sals of their own
dept.

Answers were Sorted based on User's Feedback



Delete the emps whose salaries are lowest sals of their own dept...

Answer / raji_4u

DELETE FROM EMP E1
WHERE E1.SAL =
(SELECT MIN(SAL) FROM EMP E2
WHERE E1.DEPTNO = E2.DEPTNO
)

Is This Answer Correct ?    15 Yes 3 No

Delete the emps whose salaries are lowest sals of their own dept...

Answer / nagendra

delete from emp where sal in (select min(sal) from emp group
by deptno)

Is This Answer Correct ?    7 Yes 7 No

Delete the emps whose salaries are lowest sals of their own dept...

Answer / venkyhulk1

delete from emp where eno in
(SELECT
eno
FROM
(select eno, rank() over ( partition by dno order by
salary) rank , salary from emp) e
WHERE
e.rank=1)


vgupalli@gmail.com

Is This Answer Correct ?    1 Yes 1 No

Delete the emps whose salaries are lowest sals of their own dept...

Answer / divya chaudhry

delete from emp where (depno,nvl2(sal,sal,0)) in ( select
depno,min(nvl2(sal,sal,0)) from emp group by depno )

Is This Answer Correct ?    0 Yes 3 No

Delete the emps whose salaries are lowest sals of their own dept...

Answer / roopesh kumar

delete from emp where (deptno,nvl(comm,0)) in (select
deptno,min(nvl(comm,0)) from emp
group by deptno)

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What are sql constraints?

0 Answers  


What is faster join or subquery?

0 Answers  


what are different types of keys in sql?

0 Answers  


how many ways we can we find the current date using mysql? : Sql dba

0 Answers  


Explain dml and ddl?

0 Answers  


Is sql scripting language?

0 Answers  


What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

0 Answers  


How many developers work on postgresql?

0 Answers  


Difference between table function and pipelined function?

0 Answers  


What is sql deadlock?

0 Answers  


Why function is used in sql?

0 Answers  


Categories