Code:
select
distinct
id, (select max(y.wert) from test y where y.id = t.id) as wert
from test t
where not exists(select x.id from test x where x.id = t.id and x.wert is null)
oder
Code:
select
t.id
, max(t.wert) as wert
from test t
where not exists(select x.id from test x where x.id = t.id and x.wert is null)
group by t.id
Test natürlich in deinen Tabellennamen ändern.
Frank