Category: SQL Server

0

SQL LEFT JOIN

SQL LEFT JOIN returns all the rows from the left table mentioned with the LEFT JOIN clause. If there are no matching rows in right table then output rows will return NULL values. Syntax SELECT...

0

SQL INNER JOIN

SQL INNER JOIN clause is used to combine and extract rows from two or more tables by joining common field. This common field column is compared by comparison operators like =, <, >, <=,...

0

SQL JOINS

SQL JOIN clause is used to combine and extract rows from two or more tables by joining common field. These joins are specified with FROM or WHERE clause mostly. Kindly note that INNER JOIN clause...

0

SQL LOWER() Function

SQL LOWER() function is used to convert character string from upper case to lower case. Syntax LOWER (CharacterString) Below is an example converting small letter character string to upper case. SELECT LOWER(‘SQLServerLog.com’) AS MyWebsite Upper...

0

SQL UPPER() Function

SQL UPPER() function is used to convert character string from lower case to upper case. Syntax UPPER (CharacterString) Below is an example converting small letter character string to upper case. SELECT UPPER(‘sqlserverlog.com’) AS MyWebsite...

0

SQL RIGHT() Function

SQL RIGHT() function returns substring from right side of specified string from a given column. If any column cell contains NULL value then it returns output as NULL for that value. Syntax SELECT RIGHT...