{"id":418,"date":"2024-08-28T08:46:36","date_gmt":"2024-08-28T08:46:36","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=418"},"modified":"2025-05-24T04:39:22","modified_gmt":"2025-05-24T04:39:22","slug":"as","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/as\/","title":{"rendered":"AS"},"content":{"rendered":"\n

SQL AS Keyword<\/h2>\n\n\n\n

The AS<\/code> keyword in SQL is used to rename a column or a table with an alias. An alias is a temporary name that only exists during the execution of the query. Aliases are useful for making result sets easier to read or for simplifying complex queries.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL AS Syntax<\/h2>\n\n\n\n

For columns:<\/strong><\/p>\n\n\n\n

SELECT column_name AS alias_name\nFROM table_name;<\/pre><\/div>\n\n\n\n
For tables:<\/strong><\/p>\n\n\n\n
SELECT column1, column2\nFROM table_name AS alias_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL AS for Columns<\/h2>\n\n\n\n
The following SQL statement creates two aliases, one for the first_name<\/code> column and one for the last_name<\/code> column from the Patients<\/code> table:<\/p>\n\n\n\n
SELECT first_name AS First, last_name AS Last\nFROM Patients;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
The following SQL statement creates two aliases. Notice that it uses double quotes since the alias contains a space:<\/p>\n\n\n\n
SELECT first_name AS "First Name", last_name AS "Last Name"\nFROM Patients;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
The following SQL statement creates an alias named Details<\/code> that combines three columns (first_name<\/code>, last_name<\/code>, and gender<\/code>):<\/p>\n\n\n\n
SELECT first_name || ' ' || last_name || ' - ' || gender AS Details\nFROM Patients;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
\n
Note:<\/em><\/strong> In SQLite (used in our playground), ||<\/code> is used to concatenate text values.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL AS for Tables<\/h2>\n\n\n\n
The following SQL statement selects the appointment_date<\/code> and first_name<\/code> using aliases for both the Appointments<\/code> and Patients<\/code> tables:<\/p>\n\n\n\n
SELECT a.appointment_date, p.first_name\nFROM Appointments AS a, Patients AS p\nWHERE a.patient_id = p.patient_id;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL AS Labs<\/h2>\n\n\n\n