Answer Posted / soorai ganesh

Should Implement ROW_NUMBER() method.

Just take this Example.

Create table emp(empid int, ename varchar(50),salary numeric
(9,2)

Insert into emp values(1,'Employee1',10000)
Insert into emp values(2,'Employee2',20000)
.
.
Insert into emp values(10,'Employee10',100000)

Consider the above table which have 10 records. Now u
want to select 5,6,7 Rows in this table. Just try this
query.

SELECT E.EmpID,E.EName,E.Salary FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY EmpID ASC) AS Rno, *
FROM emp
) E
WHERE E.Rno >= 5 and E.Rno <= 7

Thats all.
If anyone have other such good idea kindly share........

What is difference between primary key and foreign key?

905

---

Explain concepts of analysis services?

963

---

Data table as parameter in sql server?

1046

---

Explain what is the purpose of sql profiler in sql server?

1076

---

How to use go command in "sqlcmd"?

1205

---

Can foreign key be deleted?

924

---

What is transaction server distributed transaction?

1054

---

What is extended stored procedures?

966

---

What is conditional split?

1077

---

What are dml (data manipulation language) statements in ms sql server?

983

---

What is GUID in sql server?

1165

---

Is foreign key unique?

996

---

Explain sql server authentication modes?

1130

---

What is an identity column in insert statements?

1023

---

What action plan is preferred if sql server is not responding?

1104

---