wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records




Answers were Sorted based on User's Feedback



wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / kumar

select top 3 * from tablename
order by 1 desc

By
Kumar Junior Software Engineer

Is This Answer Correct ?    13 Yes 6 No

wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / vijaykumar dolli

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 ...!

Is This Answer Correct ?    2 Yes 1 No

wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / grace

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

Is This Answer Correct ?    3 Yes 2 No




wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / krishna sandeep

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

this will work.

Is This Answer Correct ?    2 Yes 2 No

wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / balaji

select * from table_name ORDERBY id DESC limit 0,n;

Is This Answer Correct ?    0 Yes 0 No

wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / teja

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

Is This Answer Correct ?    0 Yes 0 No

wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / amit kaishver

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)

Is This Answer Correct ?    5 Yes 6 No

wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / priya

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

Is This Answer Correct ?    15 Yes 16 No

wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / tulasi ravi kumar

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,,,.....

Is This Answer Correct ?    2 Yes 3 No

wat will be the sql query to extract only last 3 records from table supose table hving thousands f..

Answer / kumar

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

Is This Answer Correct ?    1 Yes 2 No

Post New Answer



More SQL Server Interview Questions

how can i lock the column in the table

2 Answers   Accenture,


Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  


how can u get last observation in an unknown dataset ?

0 Answers   Genpact,


WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   L&T, CarrizalSoft Technologies,


How to store pdf file in sql server?

1 Answers   TATA, CarrizalSoft Technologies, College School Exams Tests,






How send email from database?.

3 Answers   Merrill Lynch, CarrizalSoft Technologies,


what is statistics

1 Answers  


what are the advanced features in sql 2008?

2 Answers   Wipro,


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

0 Answers  


Which system table contains information on constraints on all the tables created?

2 Answers  


What is the basic difference between clustered and a non-clustered index?

9 Answers  


What is Peer to peer Replication?

1 Answers   HCL, CarrizalSoft Technologies,






Categories