So, I have a table for products and wanted to get the value from the cheaper product and its name, so I tried
select prodname,min(value) from products order by value;
and many other variations, but couldn't make it get the right name, so I suppose I should get the key from the specific row to get the right name row, but I don't know if that's possible at all.
All help is appreciated, sorry for any bad grammar or mispelling, I'm from Brazil.
