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)

Is the primary key an index?

1031

---

What is pl sql architecture?

968

---

List the different type of joins?

1064

---

What are sql commands?

1017

---

Does truncate remove indexes?

1038

---

How sql query is executed?

1140

---

What is the difference between null value, zero, and blank space?

1211

---

What does an inner join do?

1196

---

What is a sql profiler?

1034

---

Is mariadb nosql?

1048

---

How do I tune a sql query?

982

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1274

---

What is trigger explain it?

1020

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

965

---

What is memory optimized?

1092

---