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...
SQL Commands / SQL Programming / SQL Server
by Manzoor Siddiqui · Published September 15, 2015 · Last modified September 23, 2015
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...
SQL Commands / SQL Programming / SQL Server
by Manzoor Siddiqui · Published September 14, 2015 · Last modified September 23, 2015
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 =, <, >, <=,...
SQL Commands / SQL Programming / SQL Server
by Manzoor Siddiqui · Published September 13, 2015 · Last modified September 23, 2015
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...
by Manzoor Siddiqui · Published September 12, 2015 · Last modified September 23, 2015
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...
by Manzoor Siddiqui · Published September 11, 2015 · Last modified September 23, 2015
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...
by Manzoor Siddiqui · Published September 10, 2015 · Last modified September 24, 2015
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...