SQL Tutorials

Unique data searches

This example was posted by Igor on Alfred's blog…

+ Show Information

I've found SQL useful in cases when I need to see UNIQUE values of a not enumerated field(s) :

MagikSF> sql(gis_program_manager.cached_dataset(:gis))
$
SQL> select DISTINCT street from address
$
SQL> select DISTINCT zip_code, street from address
$

This way I can see the result quickly without writing _loop/_if statements.