Answer Posted / ramaniranjan das

select top1 * from (select distinct top nth from table name
by column name ) alisa name of table order by column name

Example:-Create table tab_employee
(
Emp_id int,
Emp_name varchar(50),
Emp_salary money,
Emp_deg varchar(30),
emp_add varchar(100)
);
INSERT INTO tab_employee
VALUES ('1001','ANIL','18000','MANAGER','hyd')
Go
INSERT INTO tab_employee
VALUES ('1002','AKIL','6000','CLERK','Mub')
Go
INSERT INTO tab_employee
VALUES ('1003','VINOD','7000','SALESMAN','Bang' )
GO
INSERT INTO tab_employee
VALUES ('1004','VIKAS','8000','SALESMAN','BBSR' )
GO
INSERT INTO tab_employee
VALUES ('1005','SUNIL','15000','MANAGER','Orissa' )

select top 1 * from tab_employee where Emp_salary not in
(Select Distinct top 3 Emp_salary from tab_employee order
by Emp_salary Desc)order by Emp_salary Desc

how to clone 9i Database on to 10g Database.

2336

---

What is rich query?

977

---

What is a dynamic performance view in oracle?

989

---

Give the constructs of a package, function or a procedure.

1034

---

How do I find the database name in oracle?

1035

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2096

---

What is meant by recursive hints in oracle?

1084

---

How to import one table back from a dump file?

1025

---

Difference between varchar and varchar2 data types?

1180

---

How to use attributes of the implicit cursor in oracle?

1006

---

How to rename an index?

1069

---

What is materialized view in Oracle?

1072

---

What do you mean by a tablespace?

1035

---

What to do if the startbd.bat failed to start the xe instance?

1079

---

What is a package ? What are the advantages of package ?

1085

---