Toad World® Forums

Love this Toad 5.6 feature

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

image001.png

Thank you! Nice to hear any positive feedback as well :wink:

regards,

Alexander Maximov