Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10694 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is varray in pl sql?
How to assign sql query results to pl sql variables?
How do you break a loop in pl sql?
How is a PL/SQL code compiled?
What is the basic structure of an sql?
What is basic structure of pl sql?
Explain lock escalation? : Transact sql
When you have to use a default "rollback to" savepoint of plvlog?
List the ways to get the count of records in a table?
what are the 'mysql' command line arguments? : Sql dba
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is rollback?
Is sql dba a good career? : SQL DBA
Which query operators in sql is used for pattern matching?
What do you mean by query optimization?
