Interested to Buy Any Domain ? << Click Here >> for more details...
Delete the emps whose salaries are lowest sals of their own
dept.
- 5 Answers
- 10697 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagendra
delete from emp where sal in (select min(sal) from emp group
by deptno)
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
What is the main reason behind using an index?
What does the acronym acid stand for in database management?
Does user triggers have entry for trigger with compilation errors?
What are different types of indexes?
What do you mean by dbms? What are its different types?
What is a pl/sql block?
How do I run a program in pl sql?
How to get help at the sql prompt?
What is bulk compiling in pl/sql.?
Can we use loop in sql?
Mention what does the hierarchical profiler does?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What are packages in pl sql and also explain its advantages?
What does pragma mean?
How do I upgrade sql?
