Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10721 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 embedded sql in db2?
what is the functionality of the function htmlentities? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
What is raid? How does it help storage of databases?
Write a sql query to get the third highest salary of an employee from employee_table?
What does select count (*) mean in sql?
How does sql*loader handles newline characters in a record? : aql loader
How do I start sql profiler?
How many triggers can be applied on a table?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What does cursor do in sql?
What is delimiter in pl sql?
How to find 3rd highest salary of an employee from the employee table in sql?
Do we need commit after truncate?
Define a temp table?
