Answer Posted / amit singh

Empsal table data
700
500
100
900
400
200
600
750


query to find second highest salary from table Empsal

mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
(select max(salary) from Empsal));

Output=750



query to find third highest salary from table Empsal


mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
>(select max(e1.salary) from Empsal e1
>where e1.salary IN(
>select e2.salary from Empsal e2 where
>e2.salary<(select max(salary) from Empsal))));
Output=700

RUN THE QUERY THEN ARG
amitsing2008@gmail.com(amit is back)

Does pl sql work in mysql?

989

---

What is blind sql injection?

1079

---

What is execution plan in sql?

1057

---

Is sqlite free?

981

---

Can we use ddl statements in stored procedure?

1158

---

How to run pl/sql statements in sql*plus?

1091

---

what is a database? : Sql dba

1183

---

What is the difference between count 1 and count (*) in a sql query?

1001

---

How to write a query to show the details of a student from students table whose

1004

---

What does rownum mean in sql?

1037

---

Which is better join or subquery?

1146

---

Write a sql query to get the third highest salary of an employee from employee_table?

1078

---

Explain what is sql?

1121

---

How do I find duplicates in two columns?

1178

---

Explain ttitle and btitle.

1125

---