I have a very complex sql query that joins many tables and has many subqueries. I want to add a total row using

UNION ALL

on the same statement . Do I have to perform the whole query again? Can I alias it somehow?