$ ./guess_the_languageSQL & Databases
SQL & Databases · easy · #13

What does the query return?

-- emp.dept: 'A', 'A', 'B', 'C'
SELECT COUNT(DISTINCT dept) FROM emp;
  1. 1
  2. 4
  3. 3
  4. 2
COUNT(DISTINCT dept) counts unique values: A, B and C.
Play SQL & Databases ▸