![]() | 1 | initial version |
SQL output and tag names can be modified using the AS keyword in the SELECT statement.
To modify the output name of a column, use the AS keyword followed by the desired name after the column name. For example:
SELECT column_name AS modified_name
FROM table_name;
To modify the tag name of a column, use the AS keyword followed by the desired tag name in square brackets before the column name. For example:
SELECT [tag_name]column_name
FROM table_name;
Both of these methods can be combined to modify both the output name and tag name at the same time. For example:
SELECT column_name AS modified_name, [tag_name]column_name
FROM table_name;