select statement

[mkinzler]

SQL-Code:

select 
    top 1 * 
from 
    TABELLE 
where
    PROBE in
        (select 
             distinct(PROBE) 
         from 
             tabelle
         where 
             TYP = 'M' and CHARGE = 4712);