-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|