SQL list each element one time

If you have a table like this :

CREATE TABLE data { id INTEGER , type INTEGER }

You can list each id one time with the following query :

SELECT id , MIN( type ) FROM data GROUP BY id

This work in MySQL