Oracle PL/SQL: SELECT: Get UNIQUE and DISTINCT values - The DISTINCT command retrieves only unique data entries depending on the column list you have specif

Quick Search:

Oracle PL/SQL: SELECT: Get UNIQUE and DISTINCT values

Jump to:

Category: >> Oracle PL/SQL >> SELECT: Get UNIQUE and DISTINCT values

<< last

next >>

Snippet Name: SELECT: Get UNIQUE and DISTINCT values

Description: The DISTINCT command retrieves only unique data entries depending on the column list you have specified after it.

There is no difference between DISTINCT and UNIQUE. The UNIQUE keyword was Oracle's descriptor, but ANSI standards later defined DISTINCT as the 'official' keyword. Oracle then added DISTINCT but for the sake of for backward compatibility, did not decommission the UNIQUE keyword.

Also see:
» TABLE: Using Select Statement With Data
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Using Functions
» SELECT: Get DISTINCT or UNIQUE values
» SELECT: Scalar Select
» SELECT with HAVING Clause
» SELECT with GROUP BY Clause
» SELECT with WHERE Clause
» SELECT with SAMPLE clause
» SELECT placement
» SELECT into a table
» SELECT name columns
» SELECT
» UPDATE: Update from a SELECT statement
» Inserting into SELECT statement
» INSERT with Select

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009

SELECT DISTINCT <column_name_list>
FROM <table_name>;
 
-- get all the unique cities
SELECT DISTINCT City
FROM Users
 
 
-- get the users in each city
SELECT DISTINCT LastName, City
FROM Users