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)

What are the topics in pl sql?

933

---

How does stored procedure reduce network traffic?

970

---

How we can update the view?

1007

---

How do I find duplicates in the same column?

1001

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1135

---

What is an oracle stored procedure?

995

---

How do you write an inner join query?

894

---

explain the difference between delete , truncate and drop commands? : Sql dba

1020

---

Is id a reserved word in sql?

1095

---

What is Materialized View? In What Scenario we Use Materialized View?

9404

---

What is mutating table error?

1118

---

What is right join sql?

922

---

what is the difference between sql and t-sql? : Transact sql

1044

---

What is secondary key?

883

---

Is sql database free?

928

---