Skip to content

Instantly share code, notes, and snippets.

@YiLi225

YiLi225/nullvalues2.sql

Last active December 1, 2020 02:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save YiLi225/bf9eed1b44e606358096e25ed59f5d32 to your computer and use it in GitHub Desktop.
Save YiLi225/bf9eed1b44e606358096e25ed59f5d32 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
nullvalues2.sql
/** 5.2 NULL values **/
COUNT(CASE WHEN location_var is NULL THEN id_var END) AS NULL_CNT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment