Search results
SQL Cheat Sheet provides quick, concise reference material for SQL queries, aiding users in efficiently recalling commands and syntax, facilitating faster query writing and troubleshooting during interviews or practical scenarios.
Definition and Usage. The NULLIF () function returns NULL if two expressions are equal, otherwise it returns the first expression. Syntax. NULLIF (expr1, expr2) Parameter Values. Technical Details. More Examples. Example. Compare two expressions: SELECT NULLIF('Hello', 'Hello'); Try it Yourself » Example. Compare two expressions:
The PostgreSQL cheat sheet provides you with the common PostgreSQL commands and statements that enable you to work with PostgreSQL quickly and effectively.
The following shows the syntax of the NULLIF expression: NULLIF (expression1, expression2) Code language:SQL (Structured Query Language)(sql) In this syntax, the expression1 and expression2 are scalar expressions. It means each of them evaluates to a scalar value.
Practice writing SQL to call data from the warehouse and sync it into Google Sheets in this 5 minute interactive demo. The complete guide to SQL NULLIF. Learn the syntax, parameters, use cases and find practical examples in the Hightouch SQL Dictionary.
NULLIF is equivalent to a searched CASE expression in which the two expressions are equal and the resulting expression is NULL. We recommend that you not use time-dependent functions, such as RAND(), within a NULLIF function.
Mobile-friendly Standard SQL Functions Cheat Sheet. TEXT FUNCTIONS. CONCATENATION. Use the || operator to concatenate two strings: SELECT 'Hi ' || 'there!'; -- result: Hi there! Remember that you can concatenate only character strings using ||. Use this trick for numbers: SELECT '' || 4 || 2; -- result: 42.
