MSSQL – SELECT CASE WHEN ALIAS

Wrong:

SELECT

CASE WHEN gender='1' THEN

'male' as gender_description,

'blue' as color_description

ELSE

'female' as gender_description,

'red' as color_description

END

FROM tbl_persons

Right:

SELECT

CASE WHEN gender='1' THEN 'male' ELSE 'female' END as gender_description,

CASE WHEN gender='1' THEN 'blue' ELSE 'red' END as color_description

FROM tbl_persons
This entry was posted on Tuesday, January 8th, 2019 at 10:07 amand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.