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 – BOOLEAN Table of content A Boolean is a universal data type which stores true or false values. It is used when we define a variable in a column of the table. For instance, a customer wants a list of all the red cars. So, we can find this using the BOOLEAN operator as […]