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)

Why do we need pl sql?

1037

---

How do you create a db file?

1069

---

I need a function for a train ticket reservation please answer it thanks in advance

1078

---

What is the life of an sql statement?

1076

---

Is id a reserved word in sql?

1189

---

What is data type in database?

1043

---

What is sql and db2?

1054

---

What is use of term?

1128

---

What is the use of sqldataadapter?

1026

---

What is the example of procedure?

979

---

What is normalization sql?

1118

---

What is data profiling in sql?

1139

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1125

---

How does cross join work?

1008

---

What is the meaning of disabling a trigger?

1242

---