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 basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

What are wait types?

0 Answers  

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

Why use update_statistics command in sql server?

0 Answers  

How to insert new line characters into strings?

0 Answers  

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

How to modify the underlying query of an existing view?

0 Answers  

What is it unwise to create wide clustered index keys?

0 Answers  

Which Model uses the SET concept

0 Answers   Infosys,

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,