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 most important ddl statements in sql are?

997

---

Why query optimization is needed?

930

---

What are analytical functions in sql?

1029

---

Why stored procedures are faster than query?

1027

---

What are the advantages of pl sql over sql?

1025

---

what is the difference between nested subquery and correlated subquery?

1055

---

what is offset-fetch filter in tsql? : Transact sql

949

---

How would you pass hints to the sql processor?

982

---

what is a table in a database ? : Sql dba

1041

---

what is the difference between $message and $$message? : Sql dba

998

---

what is the difference between delete and truncate statement in sql? : Sql dba

1246

---

What is right join in sql?

1091

---

Can we delete column in sql?

1100

---

what are all the different normalizations? : Sql dba

1042

---

Can you inner join the same table?

991

---