Answer the question
In order to leave comments, you need to log in
Why doesn't MIN() work in SQL query?
I make a request:
SELECT MIN(PRICE) `table` where ARTICLE='123' AND BRAND='321';
23.00
23.00
5.00
Answer the question
In order to leave comments, you need to log in
Problem solved - column was VARCHAR. Converted to DOUBLE - everything is ok.
So the record with the result "5.00" does not match the conditions "where ARTICLE='123' AND BRAND='321'"
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question