Return lower value of a SUM?

Question

I have a SELECT with SUM and would like to understand how I do to return me the lowest sum of all value per supplier.

SELECT distinct fornecedor, cliente, SUM(valor*qtd) AS TOTAL FROM orcamentos 
WHERE idOrcamento ='$orcamento' group by fornecedor;

The Table sums all values of each supplier.

I need the result to show me the lowest value found among suppliers.

Example this search above returned

|supplier | Customer | TOTAL|

|1________| 1_____ | 10.00|

|2________| 1 _____ | 11.00|

|3________| 1 _____ | 10.50|

How do I make SELECT return only the line with lower value?

Answer 1

SUM function

The function SUM() returns the total sum of a numerical column.

MIN function

The function MIN() returns the smallest value of the selected column.

Return the lowest value

As you want to return the smallest value in sql function, you should use the function MIN() instead of using the function SUM() as @Virgilionovic already responded in his comment.

Your code would look like this:

SELECT distinct fornecedor, cliente, 
MIN(valor*qtd) AS TOTAL FROM orcamentos 
WHERE idOrcamento ='$orcamento' group by 
fornecedor, cliente;