Answer Posted / arvind kumar

select * from employees e where (select count(salary) from
employees where salary >=e.salary)=2;

Does access use sql?

964

---

What are the different datatypes available in PL/SQL?

1025

---

Write a query to find the names of users that begin with "um" in sql?

921

---

What is compound trigger?

958

---

What are the different dml commands in sql?

1082

---

How does postgresql compare to oracle/db2/ms sql server/informix?

980

---

What is cte sql?

924

---

What is difference between mysql and postgresql?

1038

---

What is union, minus and interact commands?

1211

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

981

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2020

---

What is recursive join in sql?

945

---

What is rename in sql?

915

---

What is sql query optimization?

1018

---

What is t sql used for?

968

---