delete from employee where sal = (select sal from (select sal from employee

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

Question Posted / manoj

9 Answers
19118 Views
HCL, IBM, I also Faced
E-Mail Answers

Answer Posted / manoj

delete from employee where sal = (select sal from (select sal from employee order by sal desc) where rownum = 3);

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are oracle functions?

1033

How to create a stored program unit?

1234

how can we store any pdf file in oracle

2164

What happens to indexes if you drop a table?

1171

How to get a create statement for an existing table?

971

Explain an exception?

1003

What is the usage of analyze command in oracle?

1095

Can we insert data in view oracle?

1042

What is the string concatenation operator in oracle?

1178

What are the limitations oracle database 10g xe?

1046

How do I know if oracle is installed on windows?

931

How to execute a stored program unit?

1079

Is oracle the best database?

967

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2033

How do I limit the number of rows returned by an oracle query after ordering?

1171