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;

What is the difference between sql and isql*plus?

704

---

Explain foreign key in sql?

786

---

How to use sql*plus built-in timers?

768

---

What is a left join?

693

---

explain the difference between myisam static and myisam dynamic. : Sql dba

705

---

---

How do I run a pl sql program?

802

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

800

---

What are sql constraints?

788

---

how do you know if your mysql server is alive? : Sql dba

778

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

781

---

What is scope and visibility in PL/SQL?

769

---

What are pl/sql cursor exceptions?

755

---

Why functions are used in sql?

703

---

What are the limitations of sql express?

702

---

What is pivot in sql?

670

---