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 self contained sub query?

0 Answers  

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

What are views used for?

0 Answers  

What is the use of sql profiler in sql server 2012?

0 Answers  

How to list all tables in the database using odbc_tables()?

0 Answers  

Define self join?

0 Answers  

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

how to implement locking in sql server

3 Answers   Satyam,

Is foreign key a primary key?

0 Answers  

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

What is bcp? When does it use?

0 Answers