SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

June 7, 2012 by Joey Blue Leave a Comment

SQL Distinct

The SQL Distinct clause in the SQL Language allows you to remove any repeated data in a column.

Let’s take a look at the following table/query:

select * from customer; 

Here are the results from that query:

SNAGHTML1230953c

We have 6 rows and 4 columns in this table, but I only want to look at the customer_company column.

Here is the query to bring back just that column:

select customer_company from customer; 

With the following results:

SNAGHTML12327f0d

Now, I want to remove the repeated companies.  So if you look at “Dell” in the picture above, you will see that it is in there twice.

That is where the “Distinct” clause comes in.  Take a look at what happens when I put distinct into the following query:

select distinct customer_company from customer; 

I get the following results:

SNAGHTML1235ce36

Notice how we only have 5 rows.  That is because the extra/repeated Dell row has been removed.

So that is what the distinct clause does, it removes the repeated data elements in a column.

Please post any questions or comments below.

Related

Filed Under: SQL Training Tagged With: Beginning SQL, SQL Distinct, SQL Select

Leave a Question, Comment, or Reply. All are welcome! Cancel reply

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join
Copyright © 2023 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com