0

I want to select all distinct rows where a value is at its minimum. Here's an example:

Item Quantity Line
Article 1 100 1
Article 1 240 2
Article 2 150 3
Article 2 140 4
Article 2 200 5
Article 3 45 6
Article 3 60 7

I want the result to be :

Item Quantity Line
Article 1 100 1
Article 2 150 3
Article 3 45 6

So basically i need the Quantity of every Item where Line as at its lowest value. How can I do it with SQL?

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197

0 Answers0