Answer Posted / abhishekjaiswal

SELECT A.FIRST_NAME,
       A.SALARY
   FROM EMPLOYEES A
   WHERE 3 = ( SELECT COUNT(*) -- Replace 3 with any value of (N - 1)
               FROM EMPLOYEES B
               WHERE B.SALARY > A.SALARY)

what are the different type of sql's statements ? : Sql dba

874

---

Can we join more than 2 tables in sql?

950

---

what is the stuff function and how does it differ from the replace function? : Sql dba

992

---

How do you run a query?

958

---

what is a materialized view? : Sql dba

999

---

What is difference between procedure and trigger?

919

---

Explain two easy sql optimizations.

962

---

How do I kill a query in postgresql?

1014

---

Do foreign keys improve performance?

968

---

Explain the uses of control file.

994

---

What are the three forms of normalization?

996

---

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

1336

---

what is sql profiler? : Sql dba

997

---

Is left join faster than join?

985

---

What is mutating table error?

1118

---