Unanswered: Using MAX but don't want to group on everything
I have a table that has OrderDate,Customer,OrderNo. I want to pull the most recent order date by customer, and have it show me the associated OrderNo.
group by customer
will throw an error of course, and when I add in orderno into the group, I of course don't get the data I want. I'm thinking I need a subquery in order to accomplish this but I haven't quite figured it out yet.