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)

when MSQL8.0 is in market

2088

---

What is the maximum number of triggers, you can apply on a single table?

1005

---

What pl/sql package consists of?

1091

---

what is table? : Sql dba

1071

---

How is pl sql different from sql?

1099

---

write an sql query to find names of employee start with 'a'? : Sql dba

1037

---

Why truncate is faster than delete?

1121

---

What are different joins used in sql?

1067

---

what are dynamic queries in t-sql? : Transact sql

1033

---

What are different types of sql?

1199

---

How do I create a sql database?

1010

---

What does seeding a database mean?

976

---

Is there a 64 bit version of ssms?

965

---

What is bitemporal narrowing?

1315

---

What is forward declaration in pl sql?

1088

---