sql - Counting DISTINCT over multiple columns - Stack Overflow

What is it about your existing query that you don't like? If you are concerned that DISTINCT across two columns does not return just the unique permutations why not try it? It certainly works as you might expect in Oracle. SQL> select distinct deptno, job

stackoverflow.com