| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> GROUP BY question
Given a table like:
Whse CustPN Price Notes
208 34512 6.50 called to expedite on 4/2 209 34512 7.50 210 34512 7.00 208 55555 2.00 209 55555 1.50 last receiving on 4/6 was damaged
is there a way to use SQL to GROUP BY CustPN MAX(Price) and return
208 55555 2.00 209 34512 7.50
Dan Received on Wed Apr 18 2001 - 16:59:50 CDT
![]() |
![]() |