Answer Posted / g.sivanagaraju

SELECT DISTINCT(A.SAL)
FROM EMP A
WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
FROM EMP B
WHERE A.SAL<=B.SAL);

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

772

---

Write the alter statement to enable all the triggers on the t.students table.

846

---

What are the most important characteristics of pl/sql?

781

---

What are sql triggers used for?

721

---

What is faster join or subquery?

708

---

---

What is latest version of sql?

707

---

What is sharding in sql?

735

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

805

---

What are the dml statements?

852

---

How to change sql*plus system settings?

720

---

What is partition in sql query?

716

---

How do you declare a constant?

706

---

Explain how to use transactions efficiently : transact sql

714

---

What is function and procedure?

754

---

What is sqlca in db2?

687

---