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

can you implement data mining in SSRS?

157

---

How each E-R model constructs can be mapped to the relational model?

1050

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1688

---

Can we create clustered index on composite key?

1168

---

Write SQL queries on Self Join and Inner Join.

1214

---

How will you make an attribute not process? : sql server analysis services, ssas

1157

---

How to view existing indexes on an given table using sys.indexes?

1150

---

Explain trigger and trigger types?

1034

---

What is difference between sql and sql server?

1081

---

Explain powershell included in sql server 2008?

1114

---

How will you find out if there are expensive SQL statements running or not?

1069

---

What is the use of @@spid?

1047

---

How to find related tables in sql server?

1001

---

Give me a SQL Query to find out the second largest company?

1227

---

How do I schedule a sql server profiler trace?

1026

---