var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: selecting data
Please forgive me if you think I should know this.....but I am trying to:
Column1+Column2 as AA where Column1+Column2>10,
Column5+Column6 as BB where Coumn5+Column6<90
But I don't think my syntax is correct.
Would appreciate some guidance. Thanks.
And your syntax is?
Originally Posted by shajju
Post the full SQL statement and the definition (DDL) of the table.
SELECT CASE WHEN Column1+Column2 > 10
ELSE NULL END as AA
, CASE WHEN Column5+Column6 < 90
ELSE NULL END as BB