Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10696 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
How do I start pl sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is the difference among union, minus and intersect?
Mention what is the plv (pl/vision) package offers?
How to install oracle sql developer?
What are actual parameters and formal parameters?
Is primary key an index?
What is application trigger?
What is rename command in sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
How do you explain an index number?
how to select unique records from a table? : Sql dba
What are the different types of database management systems?
Explain dml and ddl?
Does sql support programming?
