Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10495 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is snowflake sql?
What is sql architecture?
What is compilation error in pl sql?
What is difference between sql and excel?
What is exit statement?
What is the difference between explicit and implicit cursors in oracle?
What is the purpose of the partition table?
What is the importance of sqlcode and sqlerrm?
What is the purpose of a secondary key?
What is the difference between a primary key and a unique key?
How can you select unique records from a table?
What is sql rowcount?
How do I view a procedure in sql?
what is the difference between blob and text? : Sql dba
What is primary key and unique key?
