Re: A newbie question about select record with distinct colum?

or use a join (is better)

select t.*
from table1 t, (select min(rowid) as r from table1 group by c1) vw where t.rowid=vw.r;

--

Regards,
Falko Rotter

_________________________________________

- Software Developer -

Rotter & Kalweit Softwaredesign GbR
Friemarer Straße 38

99867 Gotha
GERMANY