Using "Top" in SQL statement

[Yusuf]

Hi

In my table I have 70,000 records. To copy and paste into Excel, I design a new query for this table, click on SQL view and after SELECT I insert "TOP 65000".
This gives me the first 65,000 records which is perfect to paste in Excel.

Please advise me the best way to get the remainder (i.e. 5000 records) through SQL or if you know of a better way, please let me know.
These I will paste in another sheet in the workbook.

 

[SydneyGeek]

You could sort Ascending on the ID field and grab Top 65000. Then find the Max ID value in that query, and create another query with ID's higher than that value.

Denis

 

[giacomo]

As Denis suggests having a field to order by is critical, you can take the top 65000 sorted ascending on the first query and then the top 4999 sorted descending on the second query.

hth,
Giacomo