I cannot get empty result in case and it returns NULL result:
SELECT CASE WHEN ('test' IS NULL) THEN (SELECT 'null_result') ELSE (SELECT 'empty_result' WHERE 1<>1) END;
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.