CoderZone.org

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

<< lastnext >>

Snippet Name: SELECT: Get DISTINCT / UNIQUE values

Description: The UNIQUE 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 Wi...
» SELECT: Case insensitive search
» SELECT: Partition Select
» SELECT: Select For Update
» SELECT: Using Functions
» SELECT: Get UNIQUE / DISTINCT valu...
» 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 state...
» Inserting into SELECT statement
» INSERT with Select

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PHP
Last Modified: March 05th, 2009

SELECT UNIQUE <column_name_list>
FROM <table_name>;
 
-- get all the unique cities
SELECT UNIQUE City
FROM Users
 
 
-- get the users in each city
SELECT UNIQUE LastName, City
FROM Users
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 30