Skip to content
This repository has been archived by the owner on Oct 16, 2021. It is now read-only.

[feature] implement CASE expression #42

Open
BohuTANG opened this issue Mar 9, 2020 · 0 comments
Open

[feature] implement CASE expression #42

BohuTANG opened this issue Mar 9, 2020 · 0 comments
Labels
P1 Medium priority type: feature

Comments

@BohuTANG
Copy link
Contributor

BohuTANG commented Mar 9, 2020

Summary

Syntax:

CASE <cond>
  WHEN <condval1> THEN <expr1>
  [ WHEN <condvalx> THEN <exprx> ] ...
  [ ELSE <expr2> ]
END

For example:

SELECT CustomerName, City, Country
FROM Customers
ORDER BY
(CASE
    WHEN City IS NULL THEN Country
    ELSE City
END);
@BohuTANG BohuTANG added type: feature P1 Medium priority labels Mar 9, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
P1 Medium priority type: feature
Projects
None yet
Development

No branches or pull requests

1 participant