Interested to Buy Any Domain ? << Click Here >> for more details...
Select the Nth lowest value from a table?
- 4 Answers
- 5355 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahesh
select *from(select ename,sal,row_number()over(order by sal desc) rk from emp) where rk=2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
select level, min('col_name') from my_table where level = '&n' connect by prior
('col_name') <'col_name') group by level;
Example:
Given a table called emp with the following columns:
-- id number
-- name varchar2(20)
-- sal number
--
-- For the second lowest salary:
-- select level, min(sal) from emp
-- where level=2
-- connect by prior sal < sal
-- group by lev
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venkat
select * from emp minus select * from emp where rownum <= (select count(*) - &n from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / basanti
select * from(select rownum,ename from employee order by rownum desc) where rownum<=5;
| Is This Answer Correct ? | 0 Yes | 0 No |
How to count groups returned with the group by clause in oracle?
What are temporal data types in oracle?
Explain an integrity constrains?
How to delete an existing row from a table in oracle?
How to define an oracle sub procedure?
What is raw datatype in oracle?
What are the advantages of oracle?
What is the difference between PFILE and SPFILE in Oracle?
Differentiate between pre-select and pre-query?
Explain the use of record option in exp command.
Can we insert data in view oracle?
How to use subqueries in the from clause in oracle?
Oracle General 
