Answer Posted / debashis mohanty

Select Name,Deptno,Salary,Rank from
(
Select Ename Name,Deptno,Sal Salary,Rank () over(Order By Sal Desc) Rank from emp
)
Where Rank=4

How to disable a trigger name update_salary?

1197

---

tell us something about heap tables. : Sql dba

1049

---

is mysql query is case sensitive? : Sql dba

1031

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

901

---

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

893

---

What is query syntax?

915

---

What is procedure explain with example?

896

---

What are different sql data types?

958

---

what is top in tsql? : Transact sql

1026

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1062

---

What do you understand by pl/sql records?

961

---

What is a null value?

1089

---

what does it mean to have quoted_identifier on? : Sql dba

1101

---

How to create a menu in sqlplus or pl/sql?

1065

---

Explain the rollback statement?

964

---