title: select distinct and one another column of the id
body: <p>I have a table with multiple columns but I need only 2.</p>
  <pre class="lang-sql prettyprint-override"><code>select id, department from tbl
  </code></pre>
  <p>If I want to use <code>distinct</code>, how do I do that?
  This is not working:</p>
  <pre class="lang-sql prettyprint-override"><code>select id, distinct department from tbl
  </code></pre>