Answer Posted / m.raghu

answer for 101th record

select * from emp where empno in( select decode
(rownum,&n,empno) from emp);

for 4th highest sal

select distinct sal from(select empno,dense_rank() over
(order by sal desc) rnk from emp) where rnk=&n;

for 5th highest sal give n value=5
for 1-10

select distinct sal from(select empno,dense_rank() over
(order by sal desc) rnk from emp) where rnk<=&n;

How do I debug a stored procedure?

1037

---

What is left join in postgresql?

992

---

How to revise and re-run the last sql command?

1098

---

How do I view a view in sql?

886

---

What is %rowtype in pl sql?

921

---

what is datawarehouse? : Sql dba

950

---

Explain the select statement in sql?

1043

---

What does pl sql stand for?

1062

---

Why is pl sql used?

931

---

What is the use of index in hive?

957

---

How can you load microsoft excel data into oracle? : aql loader

1127

---

What is crud sql?

919

---

how to increment dates by 1 in mysql? : Sql dba

924

---

what does it mean to have quoted_identifier on? : Sql dba

1098

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3007

---