Display Only The First 1,000 Results From A Query And Hide The Rest?

[pchanger]

Hey guys,

I'm working with a large 20,000 record database. When I run the query it returns around 8,000 results.



Is there a way that I can tell it to basically:

1. Sort the 8,000 good results from lowest price to highest price based on the "Price" field

2. Display only the first 1,000 (or whatever number I choose) results and hide the remaining 7,000.


Obviously I could just view all the data, export it to excel and then delete everything I don't want, but is there a better way to do this?

~Luke

[pchanger]

(I do know how to sort stuff based on a field, but I figured I'd leave it in the question because that would have to happen BEFORE hiding the remaining results)

[Micron]

You can't "hide" results, you can only filter and sort. Sounds like you need to sort ascending on your desired field and use the TOP predicate, as in
SELECT TOP 1000 FROM...