Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 18729 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / krishna
delete from emp where sal >(select max(sal) from emp where
sal >(select max(sal) from emp where sal >(select max(sal)
from emp)));
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Is it possible to split the print reviewer into more than one region ?
How to experiment a data lock in oracle?
How to convert numbers to characters in oracle?
Query to retrieve record for a many to many relationship ?
What are the attributes that are found in a cursor?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is ordinary table in oracle?
In oracle there is column command, how will you explain that?
What are the attributes of the cursor?
Why use resource manager in Oracle?
How to pass a cursor variable to a procedure?
What is the use of file param in imp command?
What are the attributes of cursor?
What are a query and state the different types of queries and their uses?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
