Answer Posted / sujitpingale

Ans: select distinct(a.salary) from customers a where &n =
(select count(distinct(b.salary)) from customers b where
a.salary <= b.salary);

Enter value in inputbox. If you enter 1 then it will give
highest salary

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1002

---

What is the difference between drop and truncate commands?

1058

---

What is crud stand for?

996

---

What is the non-clustered index in sql?

1058

---

Explain what is rdbms?

1028

---

What are the ddl commands?

1005

---

What are the types of join and explain each?

1031

---

what is primary key? : Sql dba

1024

---

What is difference between db2 and sql?

997

---

What are different sql data types?

1039

---

Define overloaded procedure?

1077

---

what is sql profiler? : Sql dba

1038

---

What does inner join mean?

1160

---

Mention what is the plv (pl/vision) package offers?

1099

---

Does truncate need commit?

940

---