Hi All,
My table appears like this with the following columns:

Name CUSTNo ORderNo. AcctDate OrderDate OrderDescriptio n

I would like to write a ms-sql query to return the records of each customer number with the latest OrderDate. One more thing, if the customer has two separate order numbers on the same date(provided its the latest date), the query should be able to pull up both the records. Thank You