AS gives a column a clearer name
AS renames a column in the result you see — a label on the output, nothing more. The table itself doesn't change. It's most useful for calculations or cryptic column names, giving your results a clear, descriptive heading.
A tiny example
In plain English: Show me every order’s total, with the column labeled receipt_total.
SELECT total AS receipt_total
FROM orders;Query result
| receipt_total |
|---|
| 8.5 |
| 12 |
| 4.75 |
The values are the same order totals — AS only changed the heading above them.
Related SQL lessons
Ready for a break?
A fresh, bite-sized SQL puzzle waits every morning. Tap tiles, see real results. No terminal, no setup, no timers.
Try today's free SQL puzzle