Re: [SQL] DISTINCT count(*), possible?

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(at)tech(dot)com(dot)au
http://www.techphoto.org - Photography News, Stuff that Matters