Answer Posted / suba

(Instead of 3 we can find N highest value)

select min(sal) from emp e where 3>(select count(sal) from
emp where sal>e.sal);

What is the difference between alter trigger and drop trigger statements?

1041

---

What is pl sql quora?

1070

---

how can we know the number of days between two given dates using mysql? : Sql dba

990

---

how many values can the set function of mysql take? : Sql dba

932

---

What is a pragma statement?

1200

---

What does the argument [or replace] do?

1014

---

How many columns should be in an index?

901

---

What is trigger price?

924

---

Which operator is used in query for pattern matching?

1031

---

how to use case expression? : Sql dba

957

---

what are the nonstandard string types? : Sql dba

1082

---

What is the primary use of normalization?

940

---

What is difference between stored procedure and trigger?

1057

---

How does sql store data?

865

---

Why do we create stored procedures & functions in pl/sql and how are they different?

887

---