Timeline for set variable result in case statement to be used again in the same select statement
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 30, 2017 at 4:40 | comment | added | Aaron Bertrand | @edgar imho general or multi-platform SQL questions are rarely useful because so few non-trivial problems can have one single universal answer. | |
| Jan 30, 2017 at 3:44 | comment | added | Edgar Allan Bayron | thanks Aaron! I found it useful. BTW, it's for SQL Server. But I think its logically applicable to MyQSL and/or Oracle | |
| Jan 30, 2017 at 3:43 | vote | accept | Edgar Allan Bayron | ||
| Jan 29, 2017 at 3:36 | history | edited | Aaron Bertrand | CC BY-SA 3.0 |
added 2 characters in body
|
| Jan 29, 2017 at 3:22 | comment | added | ypercubeᵀᴹ |
OK then, I asked the OP on a comment. By the way, MySQL has also variables named @name and maybe other DBMS as well, I don''t know
|
|
| Jan 29, 2017 at 3:19 | comment | added | Aaron Bertrand | @ypercube Was an educated guess based on all of OP's other questions. | |
| Jan 29, 2017 at 3:13 | comment | added | ypercubeᵀᴹ |
can you change the alias = to AS alias? The question is tagged with sql only,
|
|
| Jan 29, 2017 at 3:11 | history | answered | Aaron Bertrand | CC BY-SA 3.0 |