Hi puneet

sorry, but i should have asked you of your ordr_date date formate. if it has no hours/minutes/seconds then if you have more then one order type per date, my select statment is not good for you! what you need to do is to add another condition (if you have column to us for this purpose) or, you can use min(rowid), but what you get is a remdom selection of line with thesame order date!

select min(rowid), ORDERTYPE, ORDER_DATE, NAME
from table_name a
where ORDER_DATE = (select min(ORDER_DATE )
from table_name b
where a.ordertype = b.ordertype)
group by ORDERTYPE, ORDER_DATE, NAME