Prev: Selecting Top Records from Subquery
Next: Purple Indulgence——ghd new limited edition color collection
From: Erland Sommarskog on 8 Jun 2010 03:08
Glenn (nospam(a)yahoo.com) writes:
> Thanks. I gave this a try, but it still gave me the same results -
> multiple records for each stateID, not just the one that had the highest
> amount in the "Amount" column. Am I missing something?

Sorry, I got confused over the two instances of Delegates and forgot
the important part:

WHERE b.rowno = 1



--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
First  |  Prev  | 
Pages: 1 2
Prev: Selecting Top Records from Subquery
Next: Purple Indulgence——ghd new limited edition color collection