how can i get non repeating value? I`m using sql select view : THIS IS MY SELECT VIEW,
 HOW CAN I GET NON REPEATING VALUES?

[duplicated entry][1]
*I need only one line in my view.

    SELECT 
       A.TOTAL_PRESENT,
       A."LIMIT",
       A.COST_CENTER,
       A.ID,
       A.PLANT,
       A.BUDGET_YEAR,
       A."VERSION",
       B.BUDGET_YEAR,
       B."VERSION",
       B.PLANT,
       B.CHARGE_CC,
       B.YEAR_DATE_USD
    FROM
       CMS.SUM_REPANDMAINT A,
       CMS.V_SUM_REPANDMAINT B
    WHERE 
       (A.BUDGET_YEAR = B.BUDGET_YEAR(+)) AND 
       (A."VERSION" = B."VERSION"(+)) AND 
       (A.PLANT = B.PLANT(+)) AND 
       (A.COST_CENTER = B.CHARGE_CC(+)) AND
       (B.USERNAME = '[usr_name]')


  [1]: http://i.stack.imgur.com/9ezbS.png