Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Asked: June 3, 20222022-06-03T01:47:00+00:00 2022-06-03T01:47:00+00:00

sql – How to select MIN sequence with unique pricing

[ad_1]

sql – How to select MIN sequence with unique pricing – Stack Overflow

Asked
today

Viewed
8 times

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

114k

asked 2 hours ago

alexherm

1,315

lang-sql

[ad_2]

Leave an answer

Stats