Thread: DISTINCT count(*), possible?

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

I can do it as two queries, but I don't know how to do it as one.

select count(url) as foo into temp2 from urllink group by url;
select count(foo) from temp2;


Matthew Hagerty wrote:
> 
> 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

-- 
Chris Bitmead
mailto:chris@tech.com.au
http://www.techphoto.org - Photography News, Stuff that Matters