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 triggers and its types?

992

---

What does desc stand for?

1021

---

What is the benefit of foreign key?

960

---

how do you tune the slow running queries in oracle db , explain the methodology

2048

---

Can you load data into multiple tables at once? : aql loader

1020

---

How do I debug a stored procedure?

1037

---

What can I use instead of union in sql?

902

---

what are properties of a transaction? : Sql dba

1015

---

Which data type is a composite type?

931

---

What is sql select statement?

968

---

What is a variable in sql?

949

---

discuss about myisam index statistics collection. : Sql dba

905

---

What is a sql instance vs database?

1035

---

What are inner outer left and right joins in sql?

961

---

What is difference between stored procedures and application procedures?

955

---