-
TOP query with DISTINCT
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.
-
TOP query with DISTINCT (reply)
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|