title: SQL Server query to display all columns but with distinct values in one of the columns (not grouping anything)
body: <p>I have a table with 106 columns. One of those columns is a "Type" column with 16 types. </p>
  
  <p>I want 16 rows, where the Type is distinct. So, row 1 has a type of "Construction", row 2 has a type of "Elevator PVT", etc. </p>
  
  <p>Using Navicat. </p>
  
  <p>From what I've found (and understood) so far, I can't use Distinct (because that looks across all rows), I can't use Group By (because that's for aggregating data, which I'm not looking to do), so I'm stuck. </p>
  
  <p>Please be gentle- I'm really really new at this.</p>
  
  <p>Below is a part of the table (how can I share this normally?)- it's really big so I didn't share the whole thing. Below is a partial result I'm looking for, where the Violation_Type is unique and the rest of the columns display.</p>
  
  <p>Got it.. Sheesh... (took me forever, but got it...)</p>
  
  <pre><code>  D_ID   B_ID   V_ID       V_Type      S_ID   c_f   d_y    l_u    p_s   du_p  
   ------ ------ ------- -------------- ------ ----- ------ ------ ----- ------ 
     184    117   V 032   Elevator PVT      2     8      0      0               
       4    140   V 100   Construction      1     8      0      0               
      10    116   V 122   Electric                1      8   2005     0      0  
      11    117   V 033   Boiler Local      1     0   2005      0     0       
  </code></pre>