Answer Posted / kavitha nedigunta

select a.ename,a.sal
from(select ename,sal,
dense_rank() over( order by sal desc nulls last) rk
from emp)a
where rk =5;

Does inner join remove duplicates?

522

---

What does the argument [or replace] do?

581

---

How do I save a stored procedure?

526

---

What is the use of <> sql?

553

---

What are the commands used in sql?

527

---

---

what is a table in a database ? : Sql dba

542

---

What is the reports view in oracle sql developer?

543

---

What is difference between my sql and sql?

530

---

explain the difference between bool, tinyint and bit. : Sql dba

524

---

Why stored procedure is better than query?

510

---

How do you truncate?

505

---

what is 'trigger' in sql? : Sql dba

559

---

What is the difference between view and stored procedure?

494

---

What is rank function in sql?

534

---

What is rank () in sql?

534

---