|
1 |
SELECT * FROM table WHERE some_col IS NULL OR some_col = ''; |
Posts in Category: snippets
What are the different SQL JOINs ?
There are a total of five JOINs. They are :
1. JOIN or INNER JOIN
2. OUTER JOIN
2.1 LEFT OUTER JOIN or LEFT JOIN
2.2 RIGHT OUTER JOIN or RIGHT JOIN
2.3 FULL OUTER JOIN or FULL JOIN
3. NATURAL JOIN
4. CROSS JOIN
5. SELF JOIN