Answer Posted / arun

select distinct (a.salary) from employees a
where &N = (select count (distinct(b.salary))
from employees b where a.salary <= b.salary);

What is difference between function and trigger?

966

---

What is dynamic sql in pl sql?

978

---

What is set serveroutput on in pl sql?

1191

---

What is the difference between sql and t sql?

963

---

What are different sql data types?

951

---

What is Difference Between Unique and Primary Key Constraints?

1057

---

Explain how exception handling is done in advance pl/sql?

954

---

What is attribute indicator in pl sql?

958

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

928

---

How many sectors are in a partition?

1027

---

What is a .db file?

925

---

Is sqlite free?

907

---

Name the different types of indexes in sql and define them.

1071

---

What is exit statement?

954

---

How many types of relationship are there?

973

---