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
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a data lock in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
What are transaction isolation levels supported by oracle?
What is not equal to in oracle?
How to pass parameters to procedures?
What is SQL access advisor in Oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is execute immediate in oracle?
What is bulk copy or bcp in oracle?
What privilege is needed for a user to connect to oracle server?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How do I recompile a procedure in oracle?
Explain the importance of .pll extension in oracle?
Explain enable novalidate constraint.
how can we store any pdf file in oracle