title: Limit the number of records from SQL by certain requirement
body: <p>I am using oracle developer and I have the following query. The last thing I need to complete this query is because it brings up many instances of the same customer I only want to see one result per customer. Any thoughts</p>
  
  <pre><code>SELECT CUST_FNAME, CUST_LNAME, CUST_STREET, CUST_CITY, CUST_STATE, CUST_ZIP
  FROM LGCUSTOMER,  LGBRAND , LGINVOICE
  WHERE BRAND_NAME = 'FORESTERS BEST' 
  AND lginvoice.INV_DATE BETWEEN TO_DATE('20110715','YYYYMMDD') AND            TO_DATE('20110731','YYYYMMDD')
  ORDER BY CUST_STATE, CUST_LNAME, CUST_FNAME;
  </code></pre>