DISTINCT

This lesson demonstrates how to remove duplicates from a result set using the DISTINCT clause.

DISTINCT CLAUSE

We’ll work with the DISTINCT clause in this lesson. This clause can be used to output unique rows in a result set. Remember DISTINCT is a post processing filter, meaning it is applied to the resulting rows of a query.

Example Syntax

SELECT DISTINCT col1

FROM table;

Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/21lesson.sh and wait for the MySQL prompt to start-up.

Get hands-on with 1400+ tech skills courses.