I have a table consisting of the following columns, ID
, Produto
, Compra
, Venda
and Resultado
.
I know the syntax for selecting the values I want, eg
Select * From tabela_exemplo where Produto = '030';
However, I would like to know if it is possible to add something like: Select all columns when Product is equal to 30, but from the result of this search, I do not want results to appear whose purchase is less than 0 .
That would be the idea, but I do not know how to apply it.
At1 I had expressed myself badly in the question, I think agr is easier to understand.