SQL Query to select top 10 records except for the top 10 records

[missshaikh]

SQL Query to select top 10 records except for the top 10 records

I just need aSQL Server Query that can select the next 10 records after the first top 10 records.

[deepuv04]

Hi,
try the following query

[code=sql]
select top 10 * from Table_Name
where Key_Column_Name not in (select top 10 Key_Column_Name from Table_Name)

[/code]

thanks