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 / shubhra
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
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / nitesh srivastava
select * from emp
minus
select * from emp where rownum<(select count(*)-2 from emp)
Is This Answer Correct ? | 8 Yes | 10 No |
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,,,.....
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / kumar
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
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / bobby
select * from table_name where <Primary key Column-
name> != all
(select top (@@rowcount-3) <Primary key Column-name> from
Table_name)
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / pawan k. dubey
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
)
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / arun kumar k s
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
Is This Answer Correct ? | 0 Yes | 4 No |
What do you understand by hotfixes and patches in sql server?
What is database replication? What are the different types of replication you can set up in sql server?
What is the difference between a local and a global temporary table?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What do you mean by 'normalization'?
0 Answers Ernst Young, Thomson Reuters,
Will the writetext statement activate a trigger?
can an order by clause be used in a creation of a view?
what is the difference between group and having give an example with query and sample output
Why do we use non clustered index?
How do I find query history in sql server?
What is BCP? When do we use it?
What is the use of tempdb? What values does it hold?