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

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,


What is the difference between Procedure and Function

4 Answers   TCS, Accenture, Nagarro,


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  


What is Online Index Rebuild Operation?

1 Answers  


what is IDE,DMV in sql server?

1 Answers   Value Labs,






WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   L&T, CarrizalSoft Technologies,


Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  


write coding for importing sql data into a word excel...

1 Answers   Oracle,


How can i change the column name.

12 Answers   Yardi Software, HCL,


Can you give an example of Stored Procedure?

4 Answers  


How to get number of days in a given year?

4 Answers   ADP,


WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  






Categories