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 load data from external tables to regular tables?

986

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2307

---

How to call a stored function with parameters?

969

---

What is a read write transaction in oracle?

1030

---

What are the database administrators utilities available?

971

---

What is set operator oracle?

921

---

Explain an index?

1092

---

What exactly do quotation marks around the table name do?

916

---

What are a collation and state the different types of collation sensitivity?

1092

---

How to create additional tablespaces for an new database?

969

---

How to define an anonymous block?

1072

---

Explain an integrity constrains?

1076

---

Explain table?

1060

---

What is tns name?

927

---

Why packages are used in oracle?

1000

---