Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: balu on February 27, 2018, 09:46:39 pm

Title: Sql Queries with Cases
Post by: balu on February 27, 2018, 09:46:39 pm

Hello,

i want to use sql queries with case statements like in the linked example.
https://stackoverflow.com/questions/4827751/how-to-select-the-comparison-of-two-columns-as-one-column-in-oracle
or
https://community.modeanalytics.com/sql/tutorial/sql-case/

I tried several queries but they didn´t worked.

Thanks

Title: Re: Sql Queries with Cases
Post by: Geert Bellekens on February 27, 2018, 10:04:13 pm

Hi Balu,

Please state
- the database you are using
- the queries you have already tried
- the exact error message you are getting.

Geert