Page 1 of 1

distinct

Posted: Sat Feb 21, 2004 8:50 am
by Citizen99
I have column with 30.000 records and i want to get of repeated records..

SELECT DISTINC column FROM table

doesnt work ? 1054 - Unknown column 'DISTINC' in 'field list'...

Posted: Sat Feb 21, 2004 11:26 am
by evilMind
You are spelling it like: DISTINCT right?
[mysql_man]DISTINCT[/mysql_man]

Posted: Sat Feb 21, 2004 11:52 am
by Citizen99
Now I know what is wrong... everything works fine. THX