Answer / vinay

SELECT TOP 10
ID,Name,Address
FROM TableName
WHERE ID NOT IN (SELECT TOP 10 ID FROM TableName)

Answer / govardhana r

use Row_Number() function to check for the condition so
that the row number is between 10 and 20

Answer / newbie

SELECT E.* FROM
(SELECT ROW_NUMBER() OVER (ORDER BY EmpID) AS RowCounts,
Salary FROM Emp) AS E
WHERE E.RowCounts BETWEEN 10 AND 20

Answer / santosh dwivedi

select * from
(
select rownum r,a.* from TableName a
)
where r>=10 and r<=20

Answer / upendra

USE CTE

http://www.4guysfromrolla.com/webtech/071906-1.shtml


WITH CTE_Table AS ( SELECT
Row_number() OVER (
ORDER BY
sort_Column ) AS RowNum
, premiumamount
FROM
shplaninfo )

SELECT
*
FROM
CTE_Table
WHERE
RowNum BETWEEN ( 10 ) AND ( 19 )

Answer / alex

string myquery="SELECT * FROM [Employee] WHERE
([Table_Field]<=10 AND [Table_Field]<=20)"

Answer / x.cannon

SELECT * FROM
(
SELECT NTILE(2) AS div, * FROM
(
SELECT TOP(20) FROM <table_name>
) AS tmp
) AS tmp WHERE div = 2

Answer / shilpa

with temp
as
( select row_number() over(order by city) rowid, * from
employee)
select * from temp
where rowid >= 10
and rowid <= 20

Answer / adhar jain

With temp As
(
Select columns,
row_number() Over (Order By sort_Column) As row_num
From table
)
Select * from temp where row_num between 10 and 19

Answer / philip

select Row_Number() over(order by Table_columnName) as
number from TableName where Table_columnName>=10 and
Table_columnName<=20

What is the use of for clause?

0 Answers  

what authentication modes does sql server support? : Sql server database administration

0 Answers  

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

Can you index views?

0 Answers  

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

What is service broker?

0 Answers  

Is oracle faster than sql server?

0 Answers  

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

What is normalization and what are the different forms of normalizations?

2 Answers