MSSQL – ORDER BY CASE

SELECT * FROM tbl_boje

ORDER BY

CASE
WHEN boja=0 THEN 'plavo'
WHEN boja=1 THEN 'zeleno'
WHEN boja=2 THEN 'crno'
WHEN boja=3 THEN 'bijelo'
ELSE 'nepoznato'
END
This entry was posted on Friday, August 10th, 2018 at 9:39 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.