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

How can you find out how many rows returned in a cursor?

1026

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1923

---

What are cursors and when they are useful?

1082

---

What is the sql server 2000 version number?

1074

---

Explain syntax for viewing trigger?

915

---

What is an expression in ms sql server?

1067

---

how many triggers you can have on a table? : Sql server database administration

973

---

What causes index fragmentation?

991

---

What are the diifferences between the ms sql server vs mysql?

1170

---

What happens if time-only values are provided as date and time literals?

1007

---

Explain cursor as data base object?

1036

---

What are points to remember while using the fillfactor argument?

966

---

Can you name some of the dml commands in sql?

1022

---

Explain the concept of view and Types of views in SQL server?

987

---

Where is my database stored on the hard disk in ms sql server?

1057

---