jglazer63
asked on
SQL Boolean formula in select
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.
Thanks!
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.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked perfect!
Open in new window
output is: