Answer the question
In order to leave comments, you need to log in
How to add a condition on a value from a select?
There is a conditional selection:
select field1, field2, "prod" as env from table
We need to add a condition on the "env " column:
select field1, field2, "prod" as env from table where env = "prod"
Tell me how to implement this correctly?
Answer the question
In order to leave comments, you need to log in
And what for to filter through where if in a column "env" all values are equal "prod"?
Maybe so ?
select t.* from (select field1, field2, "prod" as env from table) as t where t.env = "prod"
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question