Answer / raji_4u

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

Answer / nagendra

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

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

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 )

Answer / roopesh kumar

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

What are the different tcl commands in sql?

0 Answers  

What is difference between mysql and postgresql?

0 Answers  

What are three advantages to using sql?

0 Answers  

Does sap use sql?

0 Answers  

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

Is subquery faster than join?

0 Answers  

what is dbms? : Sql dba

0 Answers  

What is sqlca in db2?

0 Answers  

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

What is a sql driver?

0 Answers