Filtering DISTINCT records
select distinct LOC_STREET_NUMBER,LOC_STREET_NAME,LOC_STREET_SUFFIX,LOC_STREET_DIRECTION,LOC_UNIT_NUMBER,LOC_DISTRICT,LOC_LOCATION_L
from address_listing;
A sample result would be:
LOC_STREET_NUMBER LOC_STREET_NAME LOC_STREET_SUFFIX LOC_STREET_DIRECTION LOC_UNIT_NUMBER LOC_DISTRICT LOC_LOCATION_L
-------------------------------------- -------------------------------------------------- ----------------- -------------------------------------------------- --------------- 1 ARKLEDUN AVENUE 1 HAMILTON 1 ARKLEDUN AVENUE,HAMILTON
1 ARKLEDUN AVENUE HAMILTON 1 ARKLEDUN AVENUE, HAMILTON
1 ARKLEDUN AVENUE 2 HAMILTON 1 ARKLEDUN AVENUE, HAMILTON
8 CARMEN AVENUE HAMILTON 8 CARMEN AVENUE, HAMILTON
1 ARKLEDUN AVENUE 3 HAMILTON 1 ARKLEDUN AVENUE, HAMILTON