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
Answer / kumar
select top 3 * from tablename
order by 1 desc
By
Kumar Junior Software Engineer
Is This Answer Correct ? | 13 Yes | 6 No |
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 |
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 |
Answer / balaji
select * from table_name ORDERBY id DESC limit 0,n;
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
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 |
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 |
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 |
How to use user defined functions in expressions?
When cursors are useful?
two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship
What is user-defined multi-statement table-valued function?
Explain concepts of analysis services?
How to list all tables having unique constraints in any of the columns in a database.
Explain the use of containers in ssis and also their types?
What are the different ways you can create databases in sql server?
Where are sql server usernames and passwords stored in the sql server?
What is side by side migration in sql server?
What is meant by indexing files?
What is blocking and how would you troubleshoot it?