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;

What is prepared statement in sql?

1104

---

How many types of cursors are available in pl/sql?

1167

---

How do I remove sql plus from windows 10?

1147

---

What is a table in a database?

1096

---

What is a common use of group by in sql?

1097

---

what is the difference between cluster and non cluster index? : Sql dba

1079

---

What is rank function in sql?

1072

---

how is myisam table stored? : Sql dba

1099

---

What are predefined functions in sql?

1109

---

what is csv? : Sql dba

1051

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1072

---

What is difference between sql and mysql?

1197

---

What is primary key sql?

1112

---

what is auto increment? : Sql dba

1051

---

What is sqlerrm?

987

---