'Rename the data (not the columns) that the query (sql) brings without affecting the database (DB2) [duplicate]
The question is the following, I need to rename the data when it is brought in the query without affecting the database, for example, when the name of a column is changed using AS and this does not affect the database, what I want doing is purely visual,
A User table containing: Name Last name
The Name column has the following values for example:
| Name |
|---|
| Estyp |
| Carlos |
| Erik |
| Jean |
What I am looking for is that after making the query instead of returning those names, it returns the results below:
| Name | (Explanation) |
|---|---|
| Lucy | i.e. Estyp changed to Lucy |
| Edward | ... Carlos changed to Eduard |
| Aldanis | ... Erik changed to Aldanis |
| Dilam | ... Jean changed to Dilam |
All of the above is visual, it doesn't have to alter the database.
Solution 1:[1]
Something like this Select Case When example line would not "alter the DB":
Create Table test (col1 Char(50));
Insert Into Test Values ('Jean ');
Select Case When col1 = 'Jean' Then 'Dilam' End From test;
https://dbfiddle.uk/?rdbms=postgres_14&fiddle=6088ebdde60761a66b1f75fdc632fdec
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |