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;

What are the differences between number and binary_float in oracle?

0 Answers  

---

What is Segment Advisor in Oracle?

0 Answers   MCN Solutions,

---

How does oracle handle read consistency?

0 Answers  

---

What is archive log in Oracle?

0 Answers   MCN Solutions,

---

State any two functions of oracle?

0 Answers   Aricent,

---

Explain can a view based on another view?

1 Answers  

---

Use of an integrity constraint is better to validate data. Explain

0 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

0 Answers  

---

what is difference between DBMS and RDBMS?

2 Answers   Metric Stream,

---

Explain database link?

0 Answers  

---

What is an Oracle sequence?

1 Answers  

---

Which are the five query types available in oracle?

0 Answers  

---