Query for excluding TOP N records

[dolovenature]

Hi,

I need to design a query which select all records excluding the Top 5 based on totalmarks.



Example :- say I have 25 candidates and their total marks.
The candidates are divided in TWO locations.

I have to select all candidates except top 5 based on their total marks(for each location)

Can anybody help me with the query?


My 2nd question is...

Can I generate a query that will only display the results of a table excluding the results of previous three queries? If yes, how??

Regards

saikat

[orange]

How about some logic along these lines (just thinking and typing and ignoring location for the moment)

Select studentID, studentinfo from students where
studentID NOT IN (Select top 5 studentId from students where criteria for totalMarks)