Specific rows of a table

Asked

Viewed 34 times

-1

Hello! I have the table OPERATION where I have 3 columns: Codoper, Description, nauteness. I have to design the description and nature of all incoming 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 am locked in Where...

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

If anyone can give a hint or help I’m grateful.

sql

  • Where codoper in (1,3,6)

  • Thanks for the help. It worked!!

  • Seems to be missing a column indicating the type of operation...

1 answer

0


Hello!

I believe this will suit you.

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

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.