0

I have a fairly large data set with records like the below, having unique sequence numbers and price points per SKU.

SKU         ASP     SEQ
123456      25.35   2
123456      25.56   1
678901      26.39   2
678901      27.49   3

I want to select 1 record per SKU, using the min(SEQ) along with the ASP that is associated with the min(SEQ).

The desired output is:

SKU         ASP     SEQ
123456      25.56   1
678901      26.39   2

Is there a concise way to do this without first selecting the min(SEQ) and then going back to lookup the corresponding ASP?

MT0
  • 113,669
  • 10
  • 50
  • 103
alexherm
  • 1,317
  • 15
  • 28

0 Answers0