beanquery icon indicating copy to clipboard operation
beanquery copied to clipboard

Suppport `SELECT x, ... FROM ... GROUP BY x ORDER BY func(x)`

Open dnicolodi opened this issue 8 months ago • 0 comments

Namely support ordering the result rows in an aggrergate query by a function of one of the aggregate columns. Use case:

SELECT
  account, 
  sum(position) 
GROUP BY 
  account 
ORDER BY 
  account_sortkey(account)

dnicolodi avatar Jun 15 '24 21:06 dnicolodi