Hi, How do I specify multiple distinct columns in a count function. I am getting an error if I give
SQL> select count(distinct company,time,region) from test;
select count(distinct company,time,region) from test
*
ERROR at line 1:
ORA-00909: invalid number of arguments
But it works if I specify only one column
1* select count(distinct (company)) from test
SQL> /
COUNT(DISTINCT(COMPANY))
------------------------
478
Please suggest.
Thanks
Anurag