GROUP BY question
From: Dan Star <danstar_at_engman-taylor.com>
Date: Wed, 18 Apr 2001 16:59:50 -0500
Message-ID: <3ade0e70$0$14446$272ea4a1_at_news.execpc.com>
Date: Wed, 18 Apr 2001 16:59:50 -0500
Message-ID: <3ade0e70$0$14446$272ea4a1_at_news.execpc.com>
Given a table like:
is there a way to use SQL to GROUP BY CustPN MAX(Price) and return
Dan
208 55555 2.00
209 34512 7.50