title: Query to group similar columns values based on different other column value
body: <p>I would like to get the information about the legal names which has different system originator and ID. So, can anyone help me with the query?</p>
  
  <p>My Query is :</p>
  
  <pre><code> SELECT ID,
      SystemOriginator,
      LegalName
  FROM Institution
  ORDER BY LegalName,
      SystemOriginator
  </code></pre>
  
  <p>Test Data:</p>
  
  <pre><code>   ID    SystemOriginator   LegalName  
   ------ ------------------ ----------- 
    2382   MLA                FC STONE   
    2382   MLA                FC STONE   
    2171   MLA                XYZ        
    2871   New System         XYZ        
    2171   MLA                XYZ        
  </code></pre>
  
  <p>and the result I want to achieve is :</p>
  
  <pre><code>   ID    SystemOriginator   LegalName  
   ------ ------------------ ----------- 
    2382   MLA                FC STONE   
    2171   MLA                XYZ        
    2871   New System         XYZ        
  </code></pre>