title: Can you give me Alternative to Group By sql server 2008
body: <p>I have a situation where I have a Select with 6 fields but I only want to group by 3 fields.
  As you know this looks not possible.
  What do you do in these situations?</p>
  
  <p>Thanks for any feedback</p>