nezuQ/CountTags.sql

Created May 14, 2014 13:55

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nezuQ/3deef26bb2dee8e07989.js"></script>
Save nezuQ/3deef26bb2dee8e07989 to your computer and use it in GitHub Desktop.

Download ZIP

SQL-Tips。複数の条件のCountを一回で取得する。 ref: http://qiita.com/nezuq/items/9fbb2eee0f722269418b

Raw

CountTags.sql

	SELECT
	COUNT(*),
	COUNT(gender = 'm' OR null),
	COUNT(gender = 'f' OR null)
	FROM
	m_user
	;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment