Question

If you do not want a column alias to appear in all upper case characters, the column alias must be enclosed in ____________________ marks. ​

Answer 1

To keep a column alias in mixed or lower case in SQL, enclose it in either double quotation marks for databases like PostgreSQL or Oracle, or single quotation marks for MySQL.

Step-by-step explanation:

If you do not want a column alias to appear in all upper case characters, the column alias must be enclosed in double quotation marks or single quotation marks, depending on the database system you are using. In SQL, for example, to prevent an alias from being converted to uppercase, you should enclose the alias in double quotation marks ("My Alias") if you're using databases like PostgreSQL or Oracle. However, in MySQL, you would typically use single quotation marks ('My Alias').