• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Week: 3 At a Glance > Summarization Functions for Use with GROUP BY Clauses

Summarization Functions for Use with GROUP BY Clauses

COUNT(<expr>)— Returns a count of the number of non-NULL values in the rows retrieved by a SELECT statement.

COUNT(DISTINCT <expr>,[<expr...>])— Returns a count of the number of different non-NULL values.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint