Interested to Buy Any Domain ? << Click Here >> for more details...
How to find 1st, 2nd, 3rd highest using select select
statement not using rownum
- 3 Answers
- 6094 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 / ajit
select distinct *
from (select e.*,dense_rank()over(order by sal desc) rn from emp e)
where rn in (1,2,3);
| Is This Answer Correct ? | 0 Yes | 0 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 differen between key flexifild and discriptive fiexifild.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what is candidate key & super key
How to convert csv to table in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
various types of joins
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
when loggined as SYSTEM,how to display all the users of database using sql query?
Display the records between two range?
What is enter substitution variable in oracle?
What is redo log?
What are the differences between number and binary_float in oracle?
Oracle General 
