Answer Posted / basheer

ex:
Raj 200
kamal 300
hajka 500
Suresh 200
so 1st max salary is 500,2nd is 300,3rd is 200
we need 2nd maximum only(i.e 300)
Query is below

SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 2 SALARY FROM EMPLOYEE ORDER BY SALARY DESC)

I've checked this query.
it will give 2nd maximum value.
if it is 3rd max salary then use TOP 3 instead of TOP 2
if u need detail explanation:
1)
Qry: SELECT DISTINCT TOP 2 SALARY FROM EMPLOYEE ORDER BY
SALARY DESC
Output:500
300
2)
SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 2 SALARY FROM EMPLOYEE ORDER BY SALARY DESC)
ans: it gets minimum salary from subquery( from above 1st ans)

What are the two types of cursors in pl sql?

1073

---

How do you know if a relationship is 2nf?

940

---

Which sql statement is used to return only different values?

1000

---

What is sql injection owasp?

1058

---

What is the usage of the distinct keyword?

1215

---

What is trigger types of trigger?

1065

---

What are the uses of merge?

1160

---

which operator is used in query for pattern matching? : Sql dba

1002

---

What does the sign mean in sql?

984

---

How many types of privileges are available in sql?

1340

---

How to load data with sql*loader?

1046

---

how can we submit a form without a submit button? : Sql dba

983

---

Is delete faster than truncate?

1002

---

What are functions in sql?

954

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1057

---