Answer Posted / satya

Hi,

Select sal from emp e where 3>=(select count (Sal)
from emp where sal>e.sal) order by sal desc;

Regards,
Satya.k

Can primary key be changed?

529

---

Can a trigger call a stored procedure?

537

---

What is bitemporal narrowing?

739

---

How do I truncate a sql log file?

540

---

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

586

---

---

Are views faster than queries?

548

---

What is sql comments?

651

---

Is oracel sql developer written in java?

648

---

where are cookies actually stored on the hard disk? : Sql dba

582

---

What is query syntax?

523

---

What is difference between rank () row_number () and dense_rank () in sql?

580

---

Why is sql important?

583

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

669

---

What does fetching a cursor do?

617

---

What is the difference between database trigger and stored procedure?

557

---