This is a detailed tutorial of the LENGTH Function in SQL. Learn to find the number of characters of the column values using the LENGTH function. SQL LENGTH Function The LENGTH Function in SQL is used to find out the number of characters of a given string. This way, you can easily find out the […]
Tag Archives: SQL
29
Feb
Feb
This is a detailed tutorial of querying duplicate records in a database table. Learn the SQL Query to find out completely or partially duplicate rows. Duplicate Table Records There might be cases when you require to find out the duplicate records of a database table. The duplicate records refer to the table rows who are […]
06
Jan
Jan
SQL Commands are categorized into DDL, DQL, DML, DCL & TCL. Learn the commands included in each of these categories with their purpose and explanation. SQL Command Types Structured Query Language (SQL) is used to create a database(s) and perform different operations on it. There is a huge list of operations that can be performed […]
30
Dec
Dec
This is a detailed tutorial of SQL UNION Operator. Learn to combine the result set of multiple SELECT Statements into one using the UNION Operator. Use of SQL UNION Operator To combine the result set of multiple SQL SELECT Statements, the UNION operator is being used. But each of the SELECT Statements for which the […]
29
Dec
Dec
This is a detailed tutorial of SQL SELF JOIN. Learn to JOIN a database table with itself to extract a lot of useful information from the table data. Use of SQL SELF JOIN You can JOIN a database table with itself using SQL SELF JOIN. Actually, you need not use any JOIN keyword for it. […]
29
Dec
Dec
This is a detailed tutorial of SQL FULL JOIN. Learn to fetch all the records that match in the LEFT as well as in the RIGHT database tables with FULL JOIN. Use of SQL FULL JOIN SQL FULL JOIN is used to fetch all the records from the LEFT table as well as from the […]
29
Dec
Dec
This is a detailed tutorial of SQL RIGHT JOIN. Learn to fetch all records from the RIGHT database table that matches with the records from the LEFT table. Use of SQL RIGHT JOIN SQL RIGHT JOIN will fetch all the records from the RIGHT database table for which the records of the LEFT database table […]
29
Dec
Dec
This is a detailed tutorial of SQL LEFT JOIN. Learn to fetch all records from the LEFT database table that matches with the records from the RIGHT table. Use of SQL LEFT JOIN SQL LEFT JOIN will fetch all the records from the LEFT database table for which the records of the RIGHT database table […]
29
Dec
Dec
This is a detailed tutorial of SQL INNER JOIN. Learn to select the common records in two tables on the basis of a common column with INNER JOIN. Use of SQL INNER JOIN SQL INNER JOIN is used to find records in two or more tables that have matching values for a particular column. In […]
28
Dec
Dec
This is a detailed tutorial of SQL Wildcard Characters. Learn to use different wildcards to find matching pattern strings with the LIKE operator. Use of SQL Wildcard Characters Wildcard characters are used in the SQL Like Operator to create different patterns for which you want to find the values in the database tables. A single […]