SELECT DISTINCT name,* FROM tabelle oder SELECT DISTINCT name,ID FROM tabelle