Answer Posted / lalit dwivedi

select a.salary
from emp a
where 3=(select count(distinct(b.salary))
from emp b
where a.salary<=b.salary)

What is the difference between an inner and outer join?

1020

---

What is a stored procedure in sql with example?

1137

---

Can we commit inside a trigger?

998

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1046

---

What is group function in sql?

1027

---

Is there a 64 bit version of ssms?

962

---

What are the different parts of a package?

1117

---

How do you update a table in sql?

993

---

How do I add a database to sql?

1131

---

What is implicit cursor in pl sql?

1097

---

How sql query is executed?

1138

---

How do I know if I have sql express or standard?

1038

---

Is inner join same as self join?

1122

---

What is the use of function "module procedure" in pl/sql?

1200

---

What is the difference between the conventional and direct path loads? : aql loader

1405

---