Skip to content

Instantly share code, notes, and snippets.

@petdance

petdance/gist:c7662e05120f9f53849714e55475b8cd

Created September 22, 2016 18:46
Show Gist options
  • Save petdance/c7662e05120f9f53849714e55475b8cd to your computer and use it in GitHub Desktop.
Save petdance/c7662e05120f9f53849714e55475b8cd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT
COUNT(*),
DECODE( pubyear, NULL, 'Y', 'N')
FROM cadetail
WHERE
caid=:caid
GROUP BY
DECODE( pubyear, NULL, 'Y', 'N')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment