Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153875 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / sanjeev kumar p
select * from emp e1 where (3-1) = (select count(distinct
(e2.sal)) from emp e2 where e2.sal>e1.sal)
| Is This Answer Correct ? | 99 Yes | 51 No |
Post New Answer View All Answers
What is an oracle user role?
What is a schema in oracle?
What is program global area (pga) in oracle?
How data locks are respected in oracle?
What is connection pool in oracle?
What are the ansi data types supported in oracle?
How to write an inner join with the where clause in oracle?
How can we find out the current date and time in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to get execution statistics reports on query statements?
What is sequence?
What is a snapshot log?
> 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?
How to select some columns from a table in oracle?
How to count duplicated values in a column in oracle?
