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)

How many types of sql are there?

980

---

How does cross join work?

922

---

How to display the current date in sql?

1058

---

What is data manipulation language?

1175

---

What is the maximum size of sqlite database?

1092

---

Can we use rowid as primary key?

969

---

What does rownum mean in sql?

1014

---

What does plv msg allows you to do?

1125

---

Explain what is rdbms?

1021

---

What is serial sql?

960

---

What is the difference between inner join and outer join?

977

---

How do you update a table in sql?

969

---

How many types of indexes are there in sql?

975

---

how to include numeric values in sql statements? : Sql dba

1086

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1002

---