this is my first post here, i am very new to SQL. I am trying to achieve this. my table A has a column called Flag which has values 0 or 1. I need to select that column but display the results as "Yes" or "No" based on the flag. How can acheive this feature in my select statement?
Table A has column "flag"
Basic Query: select flag from A; This displays a bunch of 0s and 1s. I need to see a bunch of "Yes"s and "No"s.