TOP query with DISTINCT

[George Williams]

Have a query that uses TOP 10; but I'm not receiving unique results and haven't been able to figure out using DISTINCT with TOP. Is it possible to use TOP with DISTINCT?

Thanks for any help/suggestions.

[Mike John]

USE Northwind
GO

SELECT DISTINCT TOP 10 orderdate, freight from orders
ORDER BY freight desc

Should be roughly what you want

Mike John

KnowledgePool Ltd

------------
George Williams at 5/22/00 5:19:54 PM

Have a query that uses TOP 10; but I'm not receiving unique results and haven't been able to figure out using DISTINCT with TOP. Is it possible to use TOP with DISTINCT?

Thanks for any help/suggestions.