SQL (Structured Query Language) – NULL Values
The SQL NULL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to …
Tutorials
myTechMint – Learn Online Technical Tutorials of AWS, Hadoop, Sqoop, Talend, SQL, Python, C, C++, Java, Linux, Unix, VBA, etc in Easy and Simplified Way.
SQL (Structured Query Language) – UNIONS CLAUSE
The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows. To use this UNION …
SQL (Structured Query Language) – Using Joins
The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two …
SQL (Structured Query Language) – Constraints
Constraints are the rules enforced on the data columns of a table. These are used to limit the type of data that can go into …
SQL (Structured Query Language) – SORTING Results
The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some databases sort the query …
SQL (Structured Query Language) – Distinct Query
The SQL DISTINCT keyword/Query is used in conjunction with the SELECT statement to eliminate all the duplicate records and fetching only unique records. There may be a …
SQL (Structured Query Language) – Group By Clause
The SQL GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. This GROUP BY clause follows the WHERE clause …
