Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10553 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 mutating error?
What are stored procedures in mysql?
what is clause? : Sql dba
What is a temporal data type?
How insert into statements in sql?
What are few of the schema objects that are created using PL/SQL?
What is a pdo connection?
What is cte sql?
What is t sql used for?
What are local and global Indexes and where they are useful.
What is full join in sql?
What are stored procedures used for?
How many functions are there in sql?
How many types of triggers exist in pl/sql?
Explain what is a subquery ?
