From: Plamen@SQLStudio.com   
      
   This can be done easier using the ranking functions:   
      
   SELECT name, total_price, price_item_1, price_item_2, price_item_3   
   FROM (   
   SELECT name, total_price, price_item_1, price_item_2, price_item_3,   
           ROW_NUMBER() OVER(PARTITION BY name ORDER BY total_price DESC) AS rk   
   FROM Foo) AS T   
   WHERE rk = 1;   
      
   --   
   Plamen Ratchev   
   http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)