Skip to main content
Journey Uncommon Logo
JourneyUncommon
easySQLaliases ASSingle-choice MCQ

Can you reference a column alias defined in SELECT inside the WHERE clause of the same query (standard SQL / PostgreSQL)?

SELECT price * quantity AS total FROM line_items WHERE total > 100;