SQL SELECT DISTINCT Keyword

Concept visual

SQL SELECT DISTINCT Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

SELECT DISTINCT Keyword

Select Distinct

The SELECT DISTINCT

command returns only distinct (different) values in the result set. The following SQL statement selects only the DISTINCT values from the "Country" column in the "Customers" table:

Example

SELECT DISTINCT Country FROM Customers;

SQL SELECT DISTINCT Keyword

Concept visual

SQL SELECT DISTINCT Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

SELECT DISTINCT Keyword

Select Distinct

The SELECT DISTINCT

command returns only distinct (different) values in the result set. The following SQL statement selects only the DISTINCT values from the "Country" column in the "Customers" table:

Example

SELECT DISTINCT Country FROM Customers;

SQL SELECT DISTINCT Keyword

SQL SELECT DISTINCT Keyword

SELECT DISTINCT Keyword

Previous

Next

Select Distinct

The SELECT DISTINCT

Example

Previous

Next

SQL SELECT DISTINCT Keyword

SQL SELECT DISTINCT Keyword

SELECT DISTINCT Keyword

Previous

Next

Select Distinct

The SELECT DISTINCT

Example

Previous

Next