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 is a system tablespace?

1008

---

What is the data pump export utility?

1023

---

What is the difference between sharding and partitioning?

931

---

How many categories of data types?

940

---

How to check your oracle database 10g xe installation?

927

---

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

1815

---

How to convert numbers to characters in oracle?

971

---

What is redo log?

1006

---

Explain enable novalidate constraint.

1035

---

What is connection pool in oracle?

930

---

Name the three major set of files on disk that compose a database in Oracle?

1067

---

What is a snapshot log?

952

---

How to list all user accounts in oracle?

981

---

How do we get field detail of a table?

1022

---

Explain oracle 12c new features for developers?

995

---