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 functions in sql?

894

---

What is synonyms?

999

---

what are the limitations of identity column? : Transact sql

1046

---

Is postgresql a nosql database?

1073

---

What is the use of function in sql?

1027

---

Why is pl sql needed?

871

---

How much does sql certification cost?

1014

---

What is an alias command?

1000

---

How do I edit a stored procedure?

945

---

What does the argument [or replace] do?

1014

---

What are the packages in pl sql?

965

---

What does stand for in sql?

915

---

What is output spooling in sql*plus?

982

---

Which join is like inner join?

973

---

how to select first 5 records from a table? : Sql dba

918

---