SQL - DISTINCT (or UNIQUE)

Data System Architecture

About

A distinct is a SQL clause that remove duplicate rows.

The distinct operation is performed as a set projection in linear algebra.





Discover More
Venn Diagram
Collection - Set

A set is: a data structure of the set theory a collection ofdistinct objects (then without duplicate) an unordered collection of objects The objects element of the set have the same type (the type...
Algebra Of Tables
Relational Algebra - Project operator (Projection)

The project operator is a relational operator that keeps: only a set of columns (in other words eliminates the others). or delete attributes not in the projection list It chooses a subset of the...
Data System Architecture
Sql - Binary large object (BLOB) data type

Binary large object (BLOB) is a SQL data type suited to store a blob file (ie binary data). In a database, a blob is implemented via pointer to the local file system (known as a lob (large object) ...



Share this page:
Follow us:
Task Runner