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

If the job running very slow what is the action you do

1825

---

What is the user of Primary key?

923

---

Can we use max in where clause?

880

---

Explain the architecture of ms sql reporting service?

872

---

Benefits of Stored Procedures?

918

---

What is the maximum row of a size?

953

---

What is the most common trace flags used with sql server?

963

---

What is the correct order of the logical query processing phases?

874

---

Will count(column) include columns with null values in its count?

1033

---

what is a mixed extent? : Sql server administration

1023

---

What is user defined stored procedures?

877

---

How to connect to a sql server using odbc_connect()?

1094

---

Explain filtered indexes benefits?

951

---

Do you know what is a with(nolock)?

994

---

How many levels of sp nesting are possible?

958

---