MySQL

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

Related Searches: sql substring, sql server substring, sql select string, substring syntax in sql, sql query substring, substring mssql example, sql select only part of a string, sql server mid function, extract part of string

Related Searches: sql like, sql like statement, like operator in sql, sql starts with, like query in sql, sql like or, sql like syntax, like command in sql, like function in sql, using like in