Answer Posted / ajit

select e.*, rn
from ( select empno, ename, sal, deptno, dense_rank() over ( order by sal desc ) rn
from emp) e
where rn = & rn;

How to add, remove, modify users using sql?

1032

---

What are the set operators in sql?

1067

---

Does sql*plus have a pl/sql engine?

1067

---

what is 'mysqlcheck'? : Sql dba

1011

---

what is sp_pkeys? : Transact sql

1150

---

What does varchar include?

946

---

What version is sql?

1022

---

What is foreign key in sql with example?

929

---

what is bcp? When does it used? : Sql dba

988

---

How to select random rows from a table?

1073

---

What is scalar function in sql?

1038

---

How is indexing done in search engines?

980

---

What is the difference between the implicit and explicit cursors?

1047

---

What is an example of translating a date into julian format?

1115

---

Which is faster truncate or drop?

1043

---