Category Archives: sql

SQL – INTERSECT Table of content In mathematical set theory, the intersection of two sets is a collection of values that are common to both sets. In real-time scenarios, there will be a huge number of tables in a database that contains information. The user may find it challenging to gather common information from various […]

SQL – EXCEPT Table of content The SQL EXCEPT Operator The EXCEPT operator in SQL is used to retrieve all the unique records from the left operand (query), except the records that are present in the result set of the right operand (query). In other words, this operator compares the distinct values of the left […]

SQL – Joins Table of content The SQL Join Clause The SQL Join clause is used to combine data from two or more tables in a database. When the related data is stored across multiple tables, joins help you to retrieve records combining the fields from these tables using their foreign keys. The part of […]