Perform calculation in SQL command

Question

Perform calculation in SQL command

Navigation

#1 by (1 votes)

1

I made a select command on my table estoque where I bring the supply model , your current quantity and what your quantity minima in the inventory, for this I made query as follows:

SELECT codigosuprimento, suprimento, count (codigosuprimento) quantidade, estoqueminimo
FROM public.estoque, public.suprimento where usado = '0' and 
public.estoque.codigosuprimento = public.suprimento.codigo group by codigosuprimento, suprimento, estoqueminimo order by suprimento;

It is possible to perform a calculation on this query to bring the balance of this supply, for this I would make the account quantidade - estoqueminimo , is it possible?

sql query select

asked by anonymous 13.10.2017 / 16:02

1 answer

Sort by id in AngularJS (Javascript) Laravel 5.5 - Validate method does not exist?

score 1 · Accepted Answer

I discovered how to return what I need, I just needed to change a part of query , in the end it looks like this:

SELECT codigosuprimento, suprimento, count (codigosuprimento) quantidadeAtual, estoqueminimo, (count (codigosuprimento) - estoqueminimo) quantidadeSaldo
    FROM public.estoque, public.suprimento where usado = '0' and 
    public.estoque.codigosuprimento = public.suprimento.codigo group by codigosuprimento, suprimento, estoqueminimo order by suprimento;

Thanks for everyone's help