View Full Version : TOP Keyword


Cremate
02-18-2008, 11:16 AM
I have not found an easy way to do this yet.

Assuming I have my TOP 10 and ORDER BY parts correct, how can I absolutely restrict my results to exactly 10?

Thanks

Cremate
02-18-2008, 11:19 AM
Sort of a hack, but I just sorted on a unique field as well (we dont care which results are ommitted as long as there is exactly 10!).