← Older revision

Revision as of 09:54, 28 April 2026

(3 intermediate revisions by the same user not shown)

Line 60:

This file is provided in the Code Files link on this tutorial page.

This file is provided in the Code Files link on this tutorial page.

+

Please download and extract the file.

|| The following code file is required to practice this tutorial.

|| The following code file is required to practice this tutorial.

Line 91:

Line 93:

'''What is an Alias?'''

'''What is an Alias?'''

|| Let us see what an alias is?

|| Let us see what an alias is?

+

An alias is a temporary name given to a column or a table.

An alias is a temporary name given to a column or a table.

It improves the readability of the output.

It improves the readability of the output.

Line 155:

Line 158:

'''SELECT studentid student_id FROM students;'''

'''SELECT studentid student_id FROM students;'''

−

|| Here the '''AS''' keyword is optional, it means the query runs with or without '''AS'''.

+

|| Here the '''AS''' keyword is optional, it means the query runs with or without '''AS''' keyword.

+

Let us type this query and execute it.

Let us type this query and execute it.

+

Both the queries give the same result.

Both the queries give the same result.

Line 210:

Line 215:

Create alias names for gender and date of birth columns using different methods of  aliasing.

Create alias names for gender and date of birth columns using different methods of  aliasing.

−

SELECT * FROM students;

+

|| As an assignment, please do the following.

|| As an assignment, please do the following.

Script | Spoken-Tutorial - Recent changes [en]

PostgreSQL-Database/C2/Alias-Names/English