advantages of alias name

[Sravani saka]

Hi, can anyone tell me the advantages of alias name

[pritaeas]

It increases readability of the query result, and can shorten long queries.

[Sravani saka]

Thanq.. but Other than that, is there any other advantages ??

[IIM]

alias name has several advantages.

1. The readability of a QUERY(MOSTLY USED WITH SELECT STATEMENT) can be improved by giving a table an alias, also known as a correlation name or range variable. A table alias can be assigned either with or without the AS keyword:

* table_name AS table alias
* table_name table_alias.
2. This can also be useful on using self join.

[pixelsoul]

I have a class that builds my html tables dynamically along with the table headers to show query results, I use an alias for some of the columns to change them to something different that I want to show in my html table. I assume we're talking about all types of aliases, so I thought I would through this in there too.

[anupamduttabd]

If same column name is found in a join query of two or more tables then you must use table alias.

[Reverend Jim]

There is a certain query that you can use to check a table for duplicate records. This requires doing a JOIN on a table with itself. As far as I know, the only way to do this is by creating two aliases for the same table.