For normalization, for instance : Select stddev(col1)/avg(col1), stddev(col2)/av... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		ontologiae on Jan 31, 2023 \| parent \| context \| favorite \| on: SQL should be the default choice for data transfor... For normalization, for instance : Select stddev(col1)/avg(col1), stddev(col2)/avg(col2),... from mytable group by key. One line.

nojito on Feb 1, 2023 [–]

That's just a handful of columns. You have to manually type out each and every arrangement.

Add in if you want the new columns to be added in place and you have to bring in window functions.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact