|
The SELECT UNIQUE term is an Oracle-only SQL statement. It is equivalent to SELECT DISTINCT. The syntax for SELECT UNIQUE is as follows:
SELECT UNIQUE "column_name"
FROM "table_name"
For example, to select all distinct stores in Table Store_Information,
Table Store_Information
| store_name |
Sales |
Date |
| Los Angeles |
$1500 |
Jan-05-1999 |
| San Diego |
$250 |
Jan-07-1999 |
| Los Angeles |
$300 |
Jan-08-1999 |
| Boston |
$700 |
Jan-08-1999 |
we key in,
SELECT UNIQUE Sales FROM Store_Information
Result:
| store_name |
| $1500 |
| $250 |
| $300 |
| $700 |
SQL CONCATENATE Function >>
Link to this page: If you find this page useful, we encourage you to link to this page. Simply copy and paste the code below to your website, blog, or profile.
Copyright © 2012 1keydata.com All Rights Reserved. Privacy Policy
|