Обсуждение: RE: [QUESTIONS] COUNT (DISTINCT xxx) ?

Поиск
Список
Период
Сортировка

RE: [QUESTIONS] COUNT (DISTINCT xxx) ?

От
"Jackson, DeJuan"
Дата:
> Hi!
>
> Is there a way excluding temp tables to make a COUNT (DISTINCT xxx)
> query?
>
> Thanx for the attention!
>
>     Marin
>
I'd like to know as well.  I think that someone was trying to implement
sub-selects in aggregate functions, did that get done?
   select distinct count(col_name) from table_name;
doesn't work BTW, it gives that number of rows in the table even if
col_name has duplicates.

        -DEJ