|
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 |
Next: SQL ROUND Function
|
| Copyright © 2013 1keydata.com All Rights Reserved.
Privacy Policy |
|