TAG

Mysql

SQL Union Operator Explained [Easy Examples]

SQL Union Operator or clause is a one of the SQL Set operators which is used to merge or combine two or more SQL Select Query results into single result set.

By falgunithakker · 8 min read · SQL

SQL Server COALESCE Function with Practical Examples

The SQL Server Coalesce() function is a basic SQL function which is used to evaluate the list of values and return the first occurrence of non-NULL value. The …

By falgunithakker · 8 min read · SQL

SQL SUBSTRING Function Explained [Beginners]

SQL mainly provides three truncate functions which are working with string. SQL Substring Function, SQL Left Function, SQL Right Function

By falgunithakker · 10 min read · SQL

SQL LIKE | SQL NOT LIKE | SQL LIKE WILDCARD Examples

SQL like comparison operator is used to compare or to manipulate text with regular expression. There is a condition where we need to fetch records which do not …

By falgunithakker · 9 min read · SQL