Answer Posted / shivaprasad

Hi Every one,this query will helps you to find 1st or 2nd or
3rd or and so on salary from the employee table.

change inside distinct top (3) for respective results

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

---

What is recovery manager in Oracle?

1059

---

What are the various constraints used in oracle?

1049

---

How do I spool to a csv formatted file using sqlplus?

1039

---

Explain view?

1044

---

Explain the use of consistent option in exp command.

1074

---

What are the different types of record groups in oracle? Explain each of them

1028

---

What is blob data type in oracle?

1126

---

What are the differences between primary key and unique key?

1013

---

What are the roles of dba?

1071

---

How to pass parameters to procedures?

1039

---

What happens if you use a wrong connect identifier?

1070

---

How to select all columns of all rows from a table in oracle?

1055

---

How to see free space of each tablespace?

1037

---

What are the types of trigger in oracle?

985

---