YouTipSqlite Alias
# SQLite Aliases
You can temporarily rename a table or column to another name, which is called an **alias**. Using a table alias means renaming the table within a specific SQLite statement. The renaming is a temporary change; the actual table name in the database does not change.
Column aliases are used to rename columns in a table for a specific SQLite statement.
## Syntax
The basic syntax for **table** aliases is as follows:
SELECT column1, column2.... FROM table_name AS alias_name WHERE ;
The basic syntax for **column** aliases is as follows:
SELECT column_name AS alias_name FROM table_name WHERE ;
## Examples
Assume we have the following two tables, (1) The COMPANY table is as follows:
sqlite> select * from COMPANY;
ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 Texas 85000.0
6 Kim 22 South-Hall 45000.0
7 James 24 Houston 10000.0
(2) The second table is DEPARTMENT, as follows:
ID DEPT EMP_ID
---------- ---------- ----------
1 IT Billing 1
2 Engineering 2
3 Finance 7
4 Engineering 3
5 Finance 4
6 Engineering 5
7 Finance 6
Now, here is the usage of **table aliases**, where we use C and D as aliases for the COMPANY and DEPARTMENT tables, respectively:
sqlite> SELECT C.ID, C.NAME, C.AGE, D.DEPT
FROM COMPANY AS C, DEPARTMENT AS D
WHERE C.ID = D.EMP_ID;
The above SQLite statement will produce the following result:
ID NAME AGE DEPT
---------- ---------- ---------- ----------
1 Paul 32 IT Billing
2 Allen 25 Engineering
3 Teddy 23 Engineering
4 Mark 25 Finance
5 David 27 Engineering
6 Kim 22 Finance
7 James 24 Finance
Let's look at a **column alias** example, where COMPANY_ID is an alias for the ID column, and COMPANY_NAME is an alias for the name column:
sqlite> SELECT C.ID AS COMPANY_ID, C.NAME AS COMPANY_NAME, C.AGE, D.DEPT
FROM COMPANY AS C, DEPARTMENT AS D
WHERE C.ID = D.EMP_ID;
The above SQLite statement will produce the following result:
COMPANY_ID COMPANY_NAME AGE DEPT
---------- ------------ ---------- ----------
1 Paul 32 IT Billing
2 Allen 25 Engineering
3 Teddy 23 Engineering
4 Mark 25 Finance
5 David 27 Engineering
6 Kim 22 Finance
7 James 24 Finance
[](#)(#)
(#)[](#)
## 1 Note Write Note
1. #0 absulin
uns***ialwz@foxmail.com [](#)25 Similar to other databases, the alias keyword `as` can be omitted.
```sql
SELECT id AS identification, name AS nickname FROM company;
SELECT id identification, name AS nickname FROM company;
The results are exactly the same.
(javascript:;)absulin
uns***ialwz@foxmail.com 9 years ago (2017-10-30)
### Click to Share Note