Re: Select query with GROUP condition thens order by alphanumeric

[Chad Bourque]

chusoon,

Like I said, if you need this sorting and still want the speed, create an additional column that gets updated via triggers (insert and update). The function would be plenty fast enough to not slow down an insert or update (unless you are updating the whole table at once). Then, your sorting would be instantaneous.

HTH,
Chad