Interested to Buy Any Domain ? << Click Here >> for more details...
Select the Nth lowest value from a table?
- 4 Answers
- 5656 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 |
What are the most common interview questions on ETL Testing for experience?
Explain constraining triggers.
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to declare a local variable?
what is Single Byte Overhead...?
What language does oracle use?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How do I recompile a procedure in oracle?
How to create a new table by selecting rows from another table?
Differentiate between TRUNCATE and DELETE?
Difference between pre-select and pre-query
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Oracle General 
