MySQL

Overview of SQL WITH Clause The SQL WITH clause was introduced by Oracle in the Oracle 9i release 2 databases in standard SQL to simplify complex long queries of joins and subqueries, The SQL WITH

Overview of Concat SQL Function Concat SQL is one of the most useful string functions of SQL Server, which is used to join or to concatenate two or more strings together in an end-to-end manner

Overview of SQL NOT NULL constraint The SQL NOT NULL constraint on an attribute or column specifies that the NULL value is not allowed for that attribute, in other word, the constraint in SQL excludes

  Overview of SQL ISNULL Function SQL ISNULL is a function which is used to check or to replace Null value of specified column or expression which is the first parameter of the function, if

  SQL Time Functions - Overview In this article, you are going to learn about SQL Time Functions. Each SQL Time Function will be explained with practical and real-life examples. Like SQL Date Functions, Time

SQL left Join Multiple Tables - Overview A left outer join designates the leftmost table as the required table. a LEFT JOIN in SQL returns all rows from the left table and only the matched rows from the right.   In

  SQL Union & Union All Operator 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

Aggregate functions in SQL SQL provides us features to make group of rows using GROUP BY and HAVING clauses and perform some calculations or operations on group of rows and return single value or row.

SQL Server COALESCE Function The SQL 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 SQL Server Coalesce and IsNull