Every once in a while I stumble across a feature in Toad that I just love. This
is one of them:
I was typing this statement to get data from one of my reporting views:
SELECT b.[Product Code], b.YearInvoiced, b.MonthInvoiced, SUM
(b.QuantityInBaseUOM) as TotalQTY
FROM BookedSalesAllView b
GROUP BY
When I typed “GROUP BY ” the first option in the Toad insight list
of fields already had ALL the fields listed that were in the select statement
that would be required to make a valid group by clause! I just had to hit tab to
fill in the rest of the group by clause!
Love it!
Darren
