1.

What Are Table Aliases?

Answer»

Aliases can make it easier to WORK with table names. Using aliases is helpful when:

  •  You want to make the statement in the SQL Pane shorter and easier to read.
  • You refer to the table NAME often in your query — such as in qualifying COLUMN names — and want to be sure you STAY within a specific character-length limit for your query. (Some databases impose a maximum length for queries).
  •  You are working with multiple instances of the same table (such as in a self-join) and need a way to refer to ONE instance or the other.

Aliases can make it easier to work with table names. Using aliases is helpful when:


Discussion

No Comment Found

Related InterviewSolutions