Answer / mahesh

select *from(select ename,sal,row_number()over(order by sal desc) rk from emp) where rk=2;

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

Answer / venkat

select * from emp minus select * from emp where rownum <= (select count(*) - &n from emp);

Answer / basanti

select * from(select rownum,ename from employee order by rownum desc) where rownum<=5;

how to i write the query 'NISHI' TO N I S H I

4 Answers   Attra, Metric Stream,

---

What is cursor

4 Answers   TCS,

---

DBMS vs. RDBMS

2 Answers   TCS,

---

State and explain the different types of data models?

0 Answers  

---

Difference between open_form and call_form in oracle.

0 Answers  

---

What is the difference between substr & instr functions?

0 Answers  

---

What WHERE CURRENT OF clause does in a cursor?

2 Answers  

---

How many types of tables supported by oracle?

0 Answers  

---

Is it possible to split the print reviewer into more than one region ?

0 Answers   Oracle,

---

What is COST-based approach to optimization ?

5 Answers  

---

What is a dead lock in oracle?

0 Answers  

---

How to load excel data sheet to oracle database

0 Answers  

---