Skip to content

Instantly share code, notes, and snippets.

@ksakae1216
Created February 15, 2018 13:36
Embed
What would you like to do?
SELECT
COUNT(*) AS CNT
FROM (
SELECT
COL1
FROM
TEST_TBL
WHERE
COL1 = 'AAA'
AND
COL2 = 'BBB'
GROUP BY
COL1
) A
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment