Find the 5 customers closest to the warehouse whose warehouse ID is 3.

sdo_query_nn_example.sql

SELECT BRANCH_NAME
FROM
    BRANCHES    B,
    WAREHOUSES  W
WHERE
    W.WAREHOUSE_NAME = 'Odessa Warehouse'
    AND SDO_NN(B.GEOMETRY, W.GEOMETRY, 'sdo_num_res=5 unit=km', 1) = 'TRUE';