Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19371 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / nathan
DELETE FROM emp
WHERE empno = (SELECT empno
FROM (SELECT empno, ROWNUM rn
FROM (SELECT empno
FROM emp
ORDER BY sal DESC))
WHERE rn = 3);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is dual table oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is oracle database 10g express edition?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What are the advantages of oracle?
How to write a left outer join with the where clause in oracle?
Give syntax for SQL and ORACLE joins.
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Explain the use of grant option in exp command.
What is the sid in oracle?
What are set operators?
What is transport network substrate (tns) in oracle?
What is program global area (pga) in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Is it possible to insert comments into sql statements return in the data model editor ?
