Select the Nth lowest value from a table?
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 |
From the database level, how can you tell under which time zone a database is operating?
What is a database schema in oracle?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
What is a static data dictionary in oracle?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
why dont we assign not null constraint as table level constraint.
What is an oracle user role?
What privilege is needed for a user to create indexes in oracle?
What is a shared pool?
Please explain oracle left join with an example?
What is oracle and what are its different editions?
primary key is foreign key for the same table?