Answer Posted / lalit dwivedi

select a.salary
from emp a
where 3=(select count(distinct(b.salary))
from emp b
where a.salary<=b.salary)

What is the need of a partition key?

958

---

What's the difference between a primary key and a clustered index?

960

---

Can you call pl/sql package functions from within a fast formula?

993

---

What is a unique key and primary key and foreign key?

933

---

What is a primary key? Explain

936

---

How show all rows in sql?

989

---

What is the difference between distinct and unique in sql?

896

---

What is a unique constraint?

1029

---

What is trigger types of trigger?

1015

---

What is mutating error?

928

---

what is sp_pkeys? : Transact sql

1124

---

What is the command used to fetch first 5 characters of the string?

1355

---

Define commit?

963

---

What is auto increment in sql?

1076

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1040

---