SQL Distinct

Once a table starts getting a lot of data in it, some columns will contain duplicate values. For example, many Individuals share first names and surnames. Most of the time this isn't a problem. But sometimes you will want to find out how many unique values there are in a table. To do this you can use the DISTINCT keyword.

SQL statement

Code
SELECT DISTINCT(FirstName) FROM Individual

Source Table

IndividualId	FirstName	LastName	UserName
1	Fred	Flinstone	freddo
2	Homer	Simpson	homey
3	Homer	Brown	notsofamous
4	Ozzy	Ozzbourne	sabbath
5	Homer	Gain	noplacelike

Result

In this example, using the DISTINCT keyword, all customers with the same first name are treated as one. This results in only one entry for "Homer" (even though there are three different entries in total).

• << SQL Top
• SQL In >>

Enjoy this page?

2. Link to this page (copy/paste into your own website or blog):
   <a href="http://www.quackit.com/sql/tutorial/sql_distinct.cfm">SQL Distinct</a> from Quackit.com
3. Link to Quackit using one of these banner ads.

Thanks for supporting Quackit!