Delete the emps whose salaries are lowest sals of their own
dept.
Answer Posted / nagendra
delete from emp where sal in (select min(sal) from emp group
by deptno)
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
Is sql injection illegal?
Explain what is rdbms?
When you have to use a default "rollback to" savepoint of plvlog?
How can get second highest salary in sql?
Can we use view in stored procedure?
What is the use of desc in sql?
What is the difference between having clause and where clause?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is sql comments?
What is the trigger in sql?
how can we find the number of rows in a table using mysql? : Sql dba
how to return query output in html format? : Sql dba
What has stored procedures in sql?
Does sql view stored data?