i have a table that has 2 coulms one is order date and the other is customer id i want to know how many orders a customer did with out cuonting more than one order per day for example if in one day he hs more then one order i want to count only one i did select ord_date,cus_id from my table group by 1,2 and i still get more than one record for a custumer per date