Answer Posted / amit singh

forget the book first
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
don't args without run
amitsing2008@gmail.com(amy is back again)

Why do we use coalesce function in oracle?

1169

---

What is using clause and give example?

1109

---

Explain oracle 12c new features for developers?

1125

---

What is a trigger oracle?

1140

---

What is a procedure in oracle?

1282

---

What is a sub query? What are its various types?

1277

---

Explain an extent?

1158

---

Write a trigger example in oracle?

1117

---

How to delete a column in an existing table?

1132

---

When do you get a .pll extension in oracle? Explain its importance

1100

---

How to shutdown your 10g xe server from command line?

1153

---

What is meant by raw datatype?

1118

---

What is the difference between I and G in Oracle?

1152

---

what are steps for interface? where is exchange rate defined in which table?

2239

---

What is an Oracle Instance?

1164

---