oracle-databaseplsql

SQL - how to count unique combination of columns

I'm not sure if this is possible but I want to count the number of unique value in a table. I know to count the number of unique folderIDs I do:

select count(folderid) from folder

but I want the count of the number of unique combination of folderid and userid in the folder table. Is there a way to do this?

Solution 
  • select count(*) from (
  select distinct folderid, userid from folder
)