Distinct not working as expected with sql
<p>How does distinct work with the following table:</p>

<pre><code>id  | id2    | time
-------------------
1   | 5555 | 12
2   | 5555 | 12
3   | 5555 | 33
4   | 9999 | 44
5   | 9999 | 44
6   | 5555 | 33

select distinct * from table
</code></pre>