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;

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

what is difference between foreign key and reference key

3 Answers   AZTEC, Infosys,

---

How to export data to a csv file?

0 Answers  

---

How to pass a cursor variable to a procedure?

0 Answers  

---

What do you mean by merge in oracle?

0 Answers  

---

What happens to the current transaction if a ddl statement is executed?

0 Answers  

---

What is an Index ?

2 Answers  

---

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

0 Answers   Wipro,

---

How to create lov dynamically at runtime & attach to text field?

0 Answers  

---

What is the difference between truncate & delete command?

0 Answers  

---

Which Department has MOST NUMBER of employees?

8 Answers   IBM, LeadSquared, Mastek,

---

How to sort the query output in oracle?

0 Answers  

---