SELECT COUNT(DISTINCT colname) ...

admin

Administrator
Staff member
Hi
I 'd try to query on mysql database like this

" SELECT COUNT(distinct obj_id)
FROM mytable "

I just need only a count of unique obj_id .

I saw this method in mysql manual but It don't work ,so what's wrong ??



Mysql 3.22.29 on SunOs 5.6

Thank for all of you help

Tongdee S.
 
Back
Top