On Sun, Jan 14, 2018 at 5:40 AM, Andreas Joseph Krogh <andreas@visena.com> wrote:
På søndag 14. januar 2018 kl. 13:30:29, skrev Francisco Olarte <folarte@peoplecall.com>:
Andreas:
On Sun, Jan 14, 2018 at 1:03 PM, Andreas Joseph Krogh <andreas@visena.com> wrote: > SELECT q.* FROM ( > SELECT comp.id, comp.name > FROM company comp JOIN req r ON r.company_id = comp.id > ORDER BY LOWER(comp.name) ASC > ) AS q > ORDER BY r.status ASC
Do you see any solution sorting on a composite type without using an outer query?
Tacking on ORDER BY to an inner query is generally not the right thing to do.
