You can change the value of a selected column with the help of conditions. In select statement, case-when-statement takes if-statement’s place.
CASE WHEN condition_statement THEN if_value ELSE else_value END AS column_name
Sample of a case when statement:
CASE WHEN A.containsParameter=1 THEN 'Yes' ELSE 'No' END as containsParameter
PS: If you find this article useful please use like button 🙂 and if you have a question or a comment, don’t hesitate to share it!