Essential Books

Select distinct unique values only

suggest change 
SELECT DISTINCT ContinentCode
FROM Countries;

This query will return all DISTINCT (unique, different) values from ContinentCode column from Countries table

ContinentCode| —— OC| EU| AS| NA| AF|

SQLFiddle Demo

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

SELECT:
*SELECT
*Using the wildcard character to select all columns in a query.
*SELECT Using Column Aliases
*Select Individual Columns
*Selecting specified number of records
*Selecting with Condition
*Selecting with CASE
*Select columns which are named after reserved keywords
*Selecting with table alias
*Selecting with more than 1 condition.
*Selecting with Aggregate functions
*Get aggregated result for row groups
*Selection with sorted Results
*Selecting without Locking the table
*Select with condition of multiple values from column
*Select distinct unique values only
*Selecting with null
*Select rows from multiple tables
Table Of Contents