Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10722 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 to dump a table to a file with 'mysqldump'? : Sql dba
Is sql easier than java?
what is try_catch block in procedure
what is the difference between blob and text? : Sql dba
What are local and global Indexes and where they are useful.
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is native sql query?
Can we use ddl statements in stored procedure?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Explain what is an index?
How do I truncate a word?
What are different functions in sql?
Is sql workbench free?
Explain the uses of control file.
What is a unique key?
