title: MySQL distinct values query
body: <p>I need help with a relatively simple query. For a table:</p>
  
  <pre>
  A | B | C 
  ----------
  2   1   6
  2   2   5
  3   3   4
  4   4   3
  5   5   2
  6   6   1
  </pre>
  
  <p>I need to have an output like so:</p>
  
  <pre>
  A | B | C 
  ----------
  2   1   6
  3   3   4
  4   4   3
  5   5   2
  6   6   1
  </pre>
  
  <p>So that each value in A is distinct, but I also get the corresponding values in B and C. I know   "select distinct(A) from table"    but that only returns the values 2,3,4,5,6 and I need the values in columns B and C, too. Please help. I have a deadline fast approaching. This question is stupid and trivial, but one must walk before they can run. Thanks so much.</p>