Answer Posted / amit singh

forget the book

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 on this site)

How does sql profiler work?

968

---

Can we insert in view in sql?

1004

---

What are data types in pl sql?

1080

---

What are the main features of cursor?

1043

---

How to prepare for oracle pl sql certification?

1012

---

what is a composite primary key ? : Sql dba

1002

---

Is sql between inclusive?

1066

---

What is the best free sql database?

1001

---

What is a constraint? Tell me about its various levels.

1085

---

Can we join two tables without common column?

932

---

What is a primary key sql?

995

---

What is the order of sql select?

992

---

What is a unique constraint?

1017

---

Can we connect to postgresql using sql developer?

940

---

How do I save the results of sql query in a file?

929

---