marcoman44
IS-IT--Management
I have multiple item names with multiple costs. How do I write a query that will take the lowest cost associated by item name.
For example
Item A 56.34
Item A 34.65
Item B 78.93
Item B 67.45
I want the folowing results:
Item A 34.65
Item B 67.45
Any help is appreciated.
For example
Item A 56.34
Item A 34.65
Item B 78.93
Item B 67.45
I want the folowing results:
Item A 34.65
Item B 67.45
Any help is appreciated.