On this page

Function
Syntax
Keyword
Precautions
Example

Show all

Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Alias/ AS for Table

AS for Table

Updated on 2023-11-03 GMT+08:00

View PDF

Function

This statement is used to specify an alias for a table or the subquery result.

Syntax

1	SELECT attr_expr_list FROM table_reference [AS] alias;

Keyword

table_reference: Can be a table, view, or subquery.
As: Is used to connect to table_reference and alias. Whether this keyword is added or not does not affect the command execution result.

Precautions

The to-be-queried table must exist. Otherwise, an error is reported.
The alias must be specified before execution of the statement. Otherwise, an error is reported. You are advised to specify a unique alias.

Example

To specify alias n for table simple_table and visit the name field in table simple_table by using n.name, run the following statement:
1

SELECT n.score FROM simple_table n WHERE n.name = "leilei";
To specify alias m for the subquery result and return all the query results using SELECT * FROM m, run the following statement:
1

SELECT * FROM (SELECT * FROM simple_table WHERE score > 90) AS m;

Parent topic: Alias

Previous topic: Alias

Next topic: AS for Column

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback