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

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

What is an indexing strategy?

0 Answers  

How and why use sql server?

0 Answers  

Distinguish between commit and rollback?

0 Answers  

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

What is a Linked Server?

1 Answers  

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

What is the recovery model?

0 Answers  

how to find the second salary?

10 Answers   HCL, Prithvi,

How do you know which index a table is using?

4 Answers