How to find 1st, 2nd, 3rd highest using select select
statement not using rownum
- 2 Answers
- 4880 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhavi
SELECT sal
FROM (SELECT sal, RANK() OVER(ORDER BY sal DESC) AS rnk
FROM emp)
WHERE rnk IN (1,2,3);
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / annada
SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary
| Is This Answer Correct ? | 1 Yes | 2 No |
What are the types of partitions in oracle?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
Difference between an implicit & an explicit cursor.?
Explain database link?
Can we create trigger on view in oracle?
What are the different pseudo commands? Explain in general?
Which is better Oracle or MS SQL? Why?
How to do paging with oracle?
What is a trigger and what are its types in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What are the different types of failures that occur in Oracle database?
Oracle General 
