Nikhil Shenoy

@Shenoy07

Website

Dombivli, IndiaJoined June 2021

About

Aspiring to become an excellent developer and a better human being.

Available for

I am available for having a healthy discussion on time managment and technologies that will help me and you grow.

Nikhil Shenoy's blogs

ShenoyWritesshenoywrites.hashnode.dev26 posts

Articles Comments

Recently published

NSNikhil Shenoyshenoywrites.hashnode.devFeb 6, 2023 · 3 min read

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 ...

0

NSNikhil Shenoyshenoywrites.hashnode.devFeb 2, 2023 · 2 min read

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...

0

NSNikhil Shenoyshenoywrites.hashnode.devFeb 1, 2023 · 2 min read

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...

0

NSNikhil Shenoyshenoywrites.hashnode.devJan 30, 2023 · 2 min read

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...

0

NSNikhil Shenoyshenoywrites.hashnode.devJan 28, 2023 · 4 min read

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...

0

Nikhil Shenoy

About

Available for

Nikhil Shenoy's blogs

Recently published

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

Recently published

22. MySQL: CASE Statement

21. MySQL: COALESCE() Function

20. MySQL: IFNULL() Function

19. MySQL: EXISTS Operator

18. MySQL: HAVING Clause