SELECT DISTINCT ID_CARRER_TERM_BILL_CAREER , B UGR , C UGR FROM TABLENAME Distinct key word has to be used before the column name to eliminate the duplicate values eg Select disctinct columname, column from table name where condition.