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 is an index in sql?
What are the grouping functions?
What are the differences between DDL, DML and DCL in SQL?
0 Answers ABB, Aspire, Infogain,
Whether the updations made to the views reflect the original records in the table
How many columns can we include on clustered index ?
What is the difference between index seek vs. Index scan?
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
What is the difference between DataRow.Delete() and DataRow.Remove()?
What is scan table/view and seek table/view when its occurs? : sql server database administration
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"
What is the system function to get the current user's user id?
What are the different types of joins and what does each do?