Select * from ( select rownum k,g.* from nbfc_bank_m g) h,
(select max(rownum) a,max(rownum)-1 b,max(rownum)-2 c 
	  from nbfc_bank_m ) p
where  h.k in (p.a,p.b,p.c)

select top 3 from <table name > where < specify any
condition> order by <column ID> desc

select * from emp
minus
select * from emp where rownum<(select count(*)-2 from emp)

select column_name from table_name 997,1000

1-select * from employee where emp_id >(select count(*)-3 
from employee)

2-select * from employee where emp_id in
(
select top 3 emp_id from employee order by emp_id DESC

)

hi  this is tulasi ravi
id - ravi106109@gmail.com

 select empno,sal from emp where rowid in
 (select rowid from emp
 minus
 select rowid from emp where rownum<=(
 select count(*)-3 from emp))


feel free to mail queries,,,.....

hi  this is tulasi ravi
id - ravi106109@gmail.com

 select * from emp where rowid in
 (select rowid from emp
 minus
 select rowid from emp where rownum<=(
 select count(*)-3 from emp))


feel free to mail queries,,,.....

select top 3 * from tablename 
order by 1 desc

By
Kumar Junior Software Engineer

drop table #temp select identity(int,1,1) as SlNo, * into 
#temp from TABLE_NAME select top 3 * from #temp order by  
SlNo desc

arun_4454@yahoo.co.in

very good kumar 
a sweet and simple query
i tink u can go to microsoft for work
wat a query it is 
good keep it up

You will be do following things one by one in sql server.

first create table.

1.create table tablename(sno int identity(1,1) primar key,
names varchar(100))

insert the record one by one.

2. 
Insert into tablename(names) values ('arun')
Insert into tablename(names) values ('arun')
Insert into tablename(names) values ('arun')
Insert into tablename(names) values ('arun')
.
.
.
.
To Insert 1000 record one by one.

Then to execute the following query to get last 3 record.

select top 3 * from tablename 
order by 1 desc


you will be get the correct answer ok.

By
kumar

select top 3 <column_name> from ,table_name> order by 
<column_name> desc

this will work.

Select * From Sample Where 
Srno In (Select Top 3 srno From Sample Order  By 1 Desc)

-- Sample is a Table Name and Srno is Unique Key column
-- This is the perfect Answer ...!

select * from table_name where  <Primary key Column-
name>   != all
(select  top (@@rowcount-3) <Primary key Column-name> from 
Table_name)

This query will give last three record in the table in the 
same order.

CREATE TABLE dbo.Test1      ( 
[ID] [int] , 
[FirstName] [varchar](25), 
[LastName] [varchar](25)  
) ON [PRIMARY] 

INSERT INTO Test1 VALUES(1, 'Bob','Smith') 
INSERT INTO Test1 VALUES(2, 'Dave','Jones') 
INSERT INTO Test1 VALUES(3, 'Karen','White') 
INSERT INTO Test1 VALUES(1, 'Bob','Smith') 
INSERT INTO Test1 VALUES(4, 'Bobby','Smita') 

select identity(int,1,1) as SlNo,* into #temp from Test1

select * from (select top 3 * from #temp order by slno 
desc) a order by slno
drop table #temp

SELECT TOP 3 * FROM <TABLE_NAME> WHERE <CONDITION> ORDER BY 
<COLUMN_NAME> DESC