title: selecting distinct value order by desc
body: <p>i want to select distinct <code>customer_id</code> order by either <code>s.no</code> or <code>time</code> or anyhow<br><br></p>
  
  <pre><code>s.no     customer_id         time
  1        3                   100001
  2        2                   100002
  3        4                   100003
  4        3                   100004
  5        2                   100005
  </code></pre>
  
  <p>i am using </p>
  
  <pre><code>select distinct(customer_id) from table_name order by time DESC
  </code></pre>
  
  <p>and it is giving the answer as <code>4  2  3</code> but as i want it should be <code>2  3  4</code></p>