Answer Posted / rishab

select emp_name,salary,rownum from
(select emp_name,salary,r from
(select salary,emp_name,rownum r from
(select salary,emp_name,rownum
from emp
order by salary desc)
order by r)
where r<4 ---- this number must be n+1
order by salary)
where rownum=1;
-- yes rownum=1 works...

how to start mysql server? : Sql dba

1147

---

How to test for null values?

985

---

What is the limitation on the block size of pl/sql?

938

---

How do you select unique values in sql?

938

---

What problem one might face while writing log information to a data-base table in pl/sql?

1067

---

What is procedure function?

985

---

Explain alias in sql?

997

---

what is a materialized view? : Sql dba

999

---

What is a parameter query?

1023

---

what are the authentication modes in sql server? : Sql dba

1000

---

What is procedure and function?

924

---

how is myisam table stored? : Sql dba

999

---

Why are sql stored procedures used?

990

---

How to change sql*plus system settings?

997

---

How much does sql certification cost?

1017

---