What is a column alias?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a column alias?
Rating:
A column alias is a temporary name assigned to a column within a SQL statement. It is defined next to the column name using space or the AS keyword as a separator. By default, a column alias appears in uppercase. A column alias must be enclosed within double quotes if its case is to be preserved or it contains spaces or special characters such as $, #, etc.
A column alias cannot be used in the WHERE and GROUP BY clauses of a SELECT statement.
Rating:
Was this information helpful?
Other articles
- What is TO_CHAR (datetime) function?
- What is parent-child relationship between two tables?
- What is the syntax for creating an index?
- What is object privilege?
- What is LOWER function?