title: Assign a group name based on identical groups of rows using SQL Server
body: <p>I have a table (might end up using SQL Server) that looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/poz6V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/poz6V.png" alt="enter image description here"></a></p>
  
  <p>I would like to put products into a final grouping based on same criteria.</p>
  
  <p>For example prod-A, prod-B, prod-X all belong to same group as their criteria rows are same (can't be partial match).</p>
  
  <p>Hence I would like the output to be something like this</p>
  
  <p><a href="https://i.stack.imgur.com/YmV9e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YmV9e.png" alt="enter image description here"></a></p>
  
  <p>Any help will be appreciated. Thanks!</p>