how to avoid duplicate records in sql select query

Select distinct * from Tablename

(or)

Select distinct cust_id , order_id , cust_name , due_date  from tablename