Answer Posted / gaurav mishra

The answer query is......

Select max(sal) from emp a where (&N-1) in(select count
(distinct(b.sal)) from emp b where a.sal<b.sal);

How do you drop a trigger?

924

---

How can you create an empty table from an existing table?

1012

---

What is the difference between an inner and outer join?

963

---

What are analytical functions in sql?

972

---

Is pl sql different from sql?

938

---

What are the possible values for the boolean data field?

902

---

What is procedure in pl sql?

980

---

Do stored procedures prevent sql injection?

920

---

what is “go” in t-sql? : Transact sql

1045

---

What is asqueryable?

905

---

Is it possible for a table to have more than one foreign key?

979

---

How do you know if a relationship is 2nf?

877

---

What are the subsets of sql?

1038

---

What is synchronized subquery?

1093

---

What is set serveroutput on in pl sql?

1199

---