Answer Posted / 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

Should you normalize audio?

879

---

What number sorts of privileges are accessible in sql?

979

---

How to create a user name in a database?

993

---

What is the difference between row_number and dense_rank?

826

---

How to modify an existing user defined function?

1032

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1068

---

Can multiple columns be used in sql group by clause in ms sql server?

985

---

What is equi join with example?

1012

---

Are null values the same as that of zero or a blank space?

985

---

How to change a login name in ms sql server?

1024

---

What is TDS(Tabular Data Stream) Gateway?

121

---

What is difference between equi join and natural join?

964

---

What are the different methods available under sqlcommand class to access the data?

1058

---

What is ssl in sql server?

1011

---

What are the general features of sql server management studio? : sql server management studio

1016

---