I need the syntax for:
select (a > b) as test
Basically I need to test if value a is greater than value b in a select statement and return the boolean response. The above won't work.
I'm sure this is easy but I'm missing something. I need all the rows, not just if a>b (where) but actually a true or false.