Aggregates with DISTINCT
From SQLZOO
Revision as of 09:51, 11 July 2012 by Connor (Talk  contribs) (Created page with " <h3>Nobel database</h3> <h2>COUNT DISTINCT</h2> <p>You can find the number of <i>different</i> values using COUNT with DISTINCT</p> <p>In 1915 four prizes were award...")
Nobel database
COUNT DISTINCT
You can find the number of different values using COUNT with DISTINCT
In 1915 four prizes were awarded in three different subjects:
SELECT yr, subject, winner FROM nobel WHERE yr=1915 

COUNT(subject) gives 4; COUNT(DISTINCT subject) gives 3.
SELECT COUNT(subject), COUNT(DISTINCT subject) FROM nobel WHERE yr = 1915
SELECT COUNT(subject), COUNT(DISTINCT subject) FROM nobel WHERE yr = 1915'