Answer Posted / prasanna

select A.* from employee A where 1=(select count(distinct
B.sal) from employee B where B.sal>A.sal)

Is pl sql still used?

927

---

Why self join is used in sql?

919

---

Does pdo prevent sql injection?

886

---

How to find 3rd highest salary of an employee from the employee table in sql?

1038

---

what are the join types in tsql? : Transact sql

983

---

what is the difference between a local and a global temporary table? : Sql dba

1006

---

Why do we use procedures?

914

---

what are the differences between require and include, include_once and require_once? : Sql dba

972

---

What is multiple partition?

921

---

What is synonyms?

1000

---

What is difference between sql and excel?

1010

---

What is assignment operator in pl sql?

970

---

what is recursive stored procedure? : Sql dba

932

---

What is procedure and function in sql?

930

---

Is primary key always clustered index?

947

---