Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10550 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 the difference between numeric and autonumber?
what is sql? : Sql dba
What is the least restrictive isolation level? : Transact sql
How to change sql*plus system settings?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is rank () in sql?
What are the string functions in sql?
What does t sql mean?
What is a natural join?
Where the sql database files are stored?
What problem one might face while writing log information to a data-base table in pl/sql?
How do you update a value in sql?
what is recursive stored procedure? : Sql dba
How do I save a sql query?
What are the topics in pl sql?
