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)

What is Reduced List of Values?

2107

---

Differentiate between translate and replace?

1041

---

What is a select query statement in oracle?

901

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1047

---

What is a table index?

1018

---

How to pass parameters to procedures in oracle?

998

---

What is a tns service name?

947

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2047

---

can u plz provide me oca sql dumps please i need them

1904

---

please explain.. DB architecture ...

1971

---

How will you write a query to get a 5th rank student from a table student_report?

1817

---

What is the max number of columns in an oracle table?

934

---

What is a procedure in oracle?

1078

---

What is a schema in oracle?

968

---

How can we create the complete backup of data in the oracle.

2095

---