SQL Distinct

In a table, some of the columns may contain duplicate values. This is not a problem, however, sometimes you will want to list only the different (distinct) values in a table. The DISTINCT keyword can be used to return only distinct (different) values. SQL SELECT DISTINCT Syntax SELECT DISTINCT column_name(s) FROM table_name

Posted by stephenw on 8/24/2009

What others are suggesting

SQL DISTINCT

The SQL DISTINCT command used along with the SELECT keyword retrieves only unique data entries depending on the column list you have specified after it.

www.sql-tutorial.com/sql-distinct-sql-tutorial/ www.sql-tutorial.com/sql-distinct-sql-tutorial/

SQL SELECT DISTINCT Statement

This chapter will explain the SELECT DISTINCT statement. The SQL SELECT DISTINCT Statement. In a table, some of the columns may contain duplicate values.

www.w3schools.com/SQl/sql_distinct.asp www.w3schools.com/SQl/sql_distinct.asp

SQL COUNT() Function

SQL COUNT(DISTINCT column_name) Syntax. The COUNT(DISTINCT column_name) function returns the number of distinct values of the specified column:

www.w3schools.com/SQL/sql_func_count.asp www.w3schools.com/SQL/sql_func_count.asp

SQL DISTINCT

This SQL tutorial section introduces the keyword DISTINCT. This keyword ensures the data selected are all distinct from one another. ; SQL > SQL Commands > Distinct;

www.1keydata.com/sql/sqldistinct.html www.1keydata.com/sql/sqldistinct.html

SQL Tutorial - SQL Query Reference and Programming Examples

; SQL SELECT; SQL DISTINCT; SQL WHERE; SQL AND OR; SQL IN; SQL BETWEEN; SQL Wildcard; SQL LIKE; SQL ORDER BY; SQL Functions; SQL Average; SQL COUNT; SQL MAX; SQL MIN; SQL SUM; SQL GROUP BY; SQL HAVING; SQL ALIAS; SQL AS; SQL JOIN; SQL OUTER JOIN; SQL CONCATENATE; SQL SUBSTRING; SQL TRIM; SQL LENGTH;

www.1keydata.com/sql/sql.html www.1keydata.com/sql/sql.html

SQL "DISTINCT" and multi-fields

Hmmm. cant quite do what i want sql "distinct" and multi-fields.

www.webmasterworld.com/forum88/9204.htm

SELECT DISTINCT: A SQL Case Study — DatabaseJournal.com

There is an understanding in the database world that using a 'SELECT DISTINCT' SQL query is not a good idea, because it is essentially getting duplicate rows out of the database and then discarding them. Usually it's better to rearrange the 'WHERE' clause in the query to only get the rows you need. Error - SQL state: 22P02...

www.databasejournal.com/features/postgresql/article.php... www.databasejournal.com/features/postgresql/article.php/3437821/SELECT-DISTINCT-A-SQL-Case-Study.htm

SQL Distinct

Learn how to select unique values with the SQL DISTINCT keyword. SQL Home; Introduction; SQL Syntax; SQL Select; SQL Where; SQL Order By; SQL Top; SQL Distinct; SQL In; SQL Alias; SQL Join; SQL Inner Join; SQL Outer Join; SQL Insert; SQL Update; SQL Delete; SQL Functions; SQL Count; SQL Create; SQL Create Database;

www.quackit.com/sql/tutorial/sql_distinct.cfm www.quackit.com/sql/tutorial/sql_distinct.cfm

SQL Tutorial

SQL is a standard language for accessing databases. Our SQL tutorial will teach you how to use SQL to access and manipulate data in: SQL HOME; SQL Intro; SQL Syntax; SQL Select; SQL Distinct; SQL Where; SQL And & Or; SQL Order By; SQL Insert; SQL Update; SQL Delete;

www.w3schools.com/sql/default.asp www.w3schools.com/sql/default.asp

By The Way ... DISTINCT is not a function ...

Jeff's SQL Server Blog ; Nothing is indicating that DISTINCT should be "operating" on the employeeID column; it is just a column reference in the SELECT clause that happens to be surrounded by parenthesis. ; So, remember:

weblogs.sqlteam.com/jeffs/archive/2007/10/12/sql-distin... weblogs.sqlteam.com/jeffs/archive/2007/10/12/sql-distinct-group-by.aspx

Can't find what you're looking for? Suggest a link.

Partner Sites:

Ask Answers Evite Expedia Hotels Hotwire Life123 LiveDaily My Way