HI

I have a table called TEST which is like

ORDERTYPE ORDER_DATE NAME
---------- --------- -----------------------------
x 10-AUG-00 PUNEET
x 11-AUG-00 ssss
y 10-AUG-00 kkkk
y 11-AUG-00 PPPP


I want to find out the * from this table for each distinct order_type where order_date is min.

eg.

Answer for this will be be like

x 10-AUG-00 PUNEET
y 10-AUG-00 kkkk


Please let me know the SQL for this