DELETE FROM emp WHERE empno = (SELECT empno

How to Remove the 3rd highest salary person record from
table?

Question Posted / nathan

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

Please Help Members By Posting Answers For Below Questions

Explain the difference between replace() and translate() functions in oracle?

1041

IS it possible to built the oracle database without setting the kernal parameters?

2351

Whether any commands are used for months calculation? If so, what are they?

1099

How do I escape a reserved word in oracle?

1201

What is the difference between view and materialized view in Oracle?

1159

Where do we use decode and case statements?

1018

How to write a query with a right outer join in oracle?

1170

Explain a synonym?

1034

What is transport network substrate (tns) in oracle?

1047

How to define a specific record type?

1088

What is difference between cartesian join and cross join?

1095

What are internal user account in oracle?

1011

How to establish administrator authentication to the server?

1045

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2239

What is the use of file param in imp command?

1165