Need help with SQL query

1

This query below is running but I would like to add this extra condition; run this query only if there is data in the table STAGE.LAB.DATA.
I tried CASE and IF THEN, but I can't get it to work. Please help. Thanks

SELECT *
FROM
( SELECT EXISTS ( SELECT 1 FROM STAGE.LAB.DATA A
WHERE (A.HOT_TEMP_VALUE >= 118 AND A.HOT_TEMP_VALUE <= 122) ) AS result)
WHERE RESULT !='TRUE';

2

Maybe:

IF EXISTS(SELECT * FROM STAGE.LAB.DATA)
    SELECT ...
    FROM STAGE.LAB.DATA A
    WHERE ...
3

Hi Scott,
Thank you for your response
I'm using Snowflake and getting this error

SQL compilation error: syntax error line 1 at position 0 unexpected 'IF'

4

Sorry, I have no idea for Snowflake. This a SQL Server forum, so I assumed SQL Server syntax.

5

That's ok Scott, thank you again for your help.