Selecting just one row

[fossil]

select id
from table
group by id;