DISTINCT count(*), possible?

Поиск
Список
Период
Сортировка
От Matthew Hagerty
Тема DISTINCT count(*), possible?
Дата
Msg-id 4.1.19990615225634.009e7b60@mail.venux.net
обсуждение исходный текст
Список pgsql-sql
Greetings,

Can someone tell me how I can get this to work?

select DISTINCT count(address1) from aro;

returns 240, which is wrong.  But this:

select DISTINCT address1 from aro;

returns 219, which is exactally what I am looking for, minus the query
output.  I don't need the tuples, just a count of distinct addresses.

Thanks,
Matthew


В списке pgsql-sql по дате отправления: