select field1, min(field2) from mytable l where field2 <> '-' group by field1 order by field1, field2