Answer Posted / srinu

Hi Jyothi,

The below q uery is suitable for Nth max salary....

SELECT a.sal
FROM emp a
WHERE &N=(SELECT COUNT(DISTINCT b.sal)
FROM emp b
WHERE a.sal<=b.sal);
In the above query u can substitute any value like 1,2,..100 etc instead of &n.

Are stored procedures faster than dynamic sql?

1105

---

Is pl sql still used?

1017

---

What is record type in pl sql?

1036

---

What are the two types of cursors in pl sql?

1123

---

What is the difference between sum and count in sql?

1039

---

What is meant by user defined function?

1102

---

Which join is default?

1014

---

What is the sql case statement?

1055

---

What is a behavioral trigger?

1024

---

Can we use update in sql function?

1116

---

How do I run a sql query?

1082

---

What is the difference between the implicit and explicit cursors?

1111

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1132

---

Which is better join or subquery?

1190

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1162

---