Re: count distinct

Tim Cuthbertson schrieb:
> Try this:
>
> select count(1) from
> (select distinct col1, col2, col3, col4 from mytable);
>

See my answer to Daniel Morgan: This solves a different problem. But thanks for trying. :)

Stephan Received on Fri Jun 25 2004 - 01:36:40 CDT