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

Answer / lakram5455

SELECT TOP(3) * FROM emp ORDER BY EId DESC

Answer / nitesh srivastava

select * from emp
minus
select * from emp where rownum<(select count(*)-2 from emp)

Answer / tulasi ravi kumar

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

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

Answer / bobby

select * from table_name where <Primary key Column-
name> != all
(select top (@@rowcount-3) <Primary key Column-name> from
Table_name)

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

)

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

Answer / varun

select column_name from table_name 997,1000

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

What is the importance of concurrency control?

0 Answers  

How sql server enhances scalability of the database system?

0 Answers  

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

Explain what is public role in sql server?

0 Answers  

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

How to execute multiple stored procedures at one time in sql server?

0 Answers  

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

hi,i want t0 knom d syntax for a super key with an example

1 Answers  

What is the difference between sdf and mdf?

0 Answers