Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10337 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
Does sql*plus also have a pl/sql engine?
How to read xml file in oracle pl sql?
What are different types of functions in sql?
Explain some predefined exceptions.
How does one load ebcdic data? : aql loader
Explain the purpose of %type and %rowtype data types with the example?
What is varchar example?
What is an implicit commit?
what are null values? : Sql dba
What is sql analyzer?
What is a record in a database?
How to prepare for oracle pl sql certification?
What is trigger in sql? Explain
What is pl sql and why it is used for?
what is msql? : Sql dba
