Querying for Lowest Date out of Duplicate records

[opkpapp11]

I have a table that has a list of order information, there are multipule records per order that have information about when the order was processed. There is a day tied to the process time of each record, I need to filter out the duplicate records and get one record for an order, but that one record must be the first process time entry for that order. Anyone know how to make this query? Let me know if this doesnt make sense.

 

[PWise]

select orderno,min(processDate) as firstprocess
from orderprocesss
group by orderno

 

[eerlee]

SELECT *
FROM Orders O
WHERE OrderDate = (SELECT Max(OrderDate) FROM Orders WHERE OrderNo=O.OrderNo)

 

[eerlee]

oops, didn't notice you wanted the min date.

SELECT *
FROM Orders O
WHERE OrderDate = (SELECT MIN(OrderDate) FROM Orders WHERE OrderNo=O.OrderNo)