Supponendo che la tabella abbia un campo contatore id.
codice:select tab2.* from (select min(id) as minore from tabella group by campo3) as tab1 left join tabella as tab2 on tab1.minore = tab2.id order by tab2.id
Supponendo che la tabella abbia un campo contatore id.
codice:select tab2.* from (select min(id) as minore from tabella group by campo3) as tab1 left join tabella as tab2 on tab1.minore = tab2.id order by tab2.id