Re: count distinct

Try this:

select count(1) from

    (select distinct col1, col2, col3, col4 from mytable);

Tim Received on Wed Jun 23 2004 - 18:44:15 CDT