Nikhil Shenoy (@Shenoy07)

22. MySQL: CASE Statement

The case statement in MySQL is a conditional expression that returns a value based on one or more conditions. It is used to determine the result of a query based on different conditions. Facts to Remember: The CASE statement in MySQL can be used in ...

Feb 6, 2023 · 3 min readshenoywrites.hashnode.dev

21. MySQL: COALESCE() Function

The COALESCE function in MySQL is used to return the first non-NULL value in a list of expressions. If all expressions are NULL, the function returns NULL. This function is useful for handling missing or optional data, replacing NULL values with a de...

Feb 2, 2023 · 2 min readshenoywrites.hashnode.dev

20. MySQL: IFNULL() Function

The IFNULL() function in MySQL is a useful tool that allows you to replace NULL values with a specified value. Points To Remember: The IFNULL() function takes two arguments: the expression to be evaluated, and the replacement value to be used if the...

Feb 1, 2023 · 2 min readshenoywrites.hashnode.dev

19. MySQL: EXISTS Operator

The EXISTS operator is a logical operator in MySQL used to test if a subquery returns any rows. The EXISTS operator returns a boolean value, either TRUE or FALSE, depending on whether the subquery returns any rows. EXISTS Operator: The EXISTS operat...

Jan 30, 2023 · 2 min readshenoywrites.hashnode.dev

18. MySQL: HAVING Clause

The HAVING clause in MySQL is used in conjunction with the GROUP BY clause to filter the results of a query based on aggregate values. It is used to filter groups based on a specified condition, similar to how the WHERE clause is used to filter indiv...

Jan 28, 2023 · 4 min readshenoywrites.hashnode.dev

Nikhil Shenoy

About

Available for

Nikhil Shenoy's blogs

22. MySQL: CASE Statement

21. MySQL: COALESCE() Function

20. MySQL: IFNULL() Function

19. MySQL: EXISTS Operator

18. MySQL: HAVING Clause

Nikhil Shenoy

About

Available for

Nikhil Shenoy's blogs

22. MySQL: CASE Statement

21. MySQL: COALESCE() Function

20. MySQL: IFNULL() Function

19. MySQL: EXISTS Operator

18. MySQL: HAVING Clause

Nikhil Shenoy

About

Available for

Nikhil Shenoy's blogs

22. MySQL: CASE Statement

21. MySQL: COALESCE() Function

20. MySQL: IFNULL() Function

19. MySQL: EXISTS Operator

18. MySQL: HAVING Clause

Search Hashnode

Nikhil Shenoy

About

Available for

Nikhil Shenoy's blogs

22. MySQL: CASE Statement

21. MySQL: COALESCE() Function

20. MySQL: IFNULL() Function

19. MySQL: EXISTS Operator

18. MySQL: HAVING Clause