Select top 10 records except for the top 10 records

londis · Web Design Newbie Joined: Jul 18, 2004 Posts: 47

I want an SQL query - select top 10 records except for the top 10 records.

Have some theory, i think it should work, i havnt figure it out yet. I couldnt get my sql running.

I just need a SQL statement that

SELECT TOP 10 records
FROM table
WHERE records NOT (SELECT TOP 10 from table)

its not working and it wont run as i expect it.

select top 10 * employees
from employees
where NOT employee_id IN (select top 10 employee_id from employee)

no views pls. just sql statement.

basically the query means select the next 10 records after the first top 10 records

Jon · Web Design Admin Joined: Jul 12, 2004 Posts: 72

Did you try doing the following:

SELECT TOP 20 *
FROM Table T1
WHERE T1.Col1 NOT IN (SELECT TOP 10 Col1 FROM Table)
_________________
Free Music Cpop Server Definition