Category Archives: SQL Operators

SQL UNION Operator – Unification of Sets with Example

UNION operator makes it possible to connect 2 results of query and remove all existing duplicities in them. In other words, operator actually performs DISTINCT in final unification of records. Syntax SELECT Column FROM dbo.Table WHERE Condition      UNION SELECT Column FROM dbo.Table WHERE Condition; Syntax is same as in all Set operators. Result… Read More »

SQL BETWEEN Operator – Defining Range in a Condition with Examples

This operator is used in SQL whenever it is needed to prove if certain value belongs to some range. This operator is used together with “AND” command which defines given range. Operator can be used in most of the clauses but is most common in WHERE for defining limiting requirement. Syntax SELECT [Date] FROM [dbo].[Table]… Read More »