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

what exactly sql injuction.how to overcome.....

2516

---

What is the use of group by clause?

931

---

What are key constraints?

960

---

Can one drop a column from a table?

1002

---

Explain sql delete command?

1028

---

What does the on delete cascade option do?

999

---

What is the security principal at the database level that represents your session?

921

---

Differentiate between ms sql server reporting services vs crystal reports?

889

---

How to connect Azure federated root database and apply federation in entity framework?

107

---

What are two difference between sql azure and azure tables?

159

---

What is plan freezing?

951

---

Why truncate is ddl?

1067

---

What is the Main Difference between ACCESS and SQL SERVER?

1114

---

How to select true false based on column value in sql server?

996

---

How to insert data with null values?

1006

---