%%sql
SELECT *
FROM invoice
INNER JOIN(
SELECT MAX(total) t
FROM invoice
)maxtotal
ON maxtotal.t = invoice.total
With the output above I do not get the column name ‘total’ in the output please could you advise why not and how to get it?
I have selected all columns : SELECT *
so believed I would see all column names.
This is an ad-hoc query , although related to mission chinook
See far right column in screenshot below the fitrst output table has ‘total’ bottom does not.
