Specific lines of a table

-1

Hello! I have the table OPERACAO where I have 3 columns: Codoper, description, nautureza. I have to design the description and nature of all input operations. Then sort by the operation code. Operation code 1, 3 and 6 are my input operations. Code 2, 4 and 5 are output. I'm locked in where ...

Select operacao.descricao, operacao.natureza, operacao.codoper
From operacao
Where ___________________
Order by operacao.codoper

If anyone can give a tip or help, I'm grateful.

    
asked by anonymous 07.10.2018 / 16:32

1 answer

0

Hello

I believe this will fit you.

WHERE operacao.codoper IN (1, 3, 6)

    
09.10.2018 / 15:31