Which way is better between:
SELECT COUNT( CASE WHEN val IS NOT NULL THEN val ELSE 0 END) OVER() c
compare to
SELECT CASE WHEN val IS NOT NULL THEN COUT(*) OVER() ELSE 0 END c
Which way is better between:
SELECT COUNT( CASE WHEN val IS NOT NULL THEN val ELSE 0 END) OVER() c
compare to
SELECT CASE WHEN val IS NOT NULL THEN COUT(*) OVER() ELSE 0 END c