Blog · Guide

SQL AS Explained: Rename Columns in the Result

AS gives a column a clearer name in the output — product_name instead of name, list_price instead of price.

customers first_name last_name city result first_name · city
SELECT chooses which columns appear in the result.

Rename for readability

SELECT name AS product_name, price AS list_price
FROM products;

The table still stores name and price. Only the result headers change. Handy when you calculate qty * price AS line_total.

Try it yourself

The fastest way to lock this in is a short drill on the same Northstar Market tables.

Practice AS aliases

Related guides