-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|