3 ms·
I use to write complex SQL query very usually, and I can say that it's far more concise than imperative code. Compared to it's own semantics, SQL is actually ve
by ontologiae 4y ago
I use to write complex SQL query very usually, and I can say that it's far more concise than imperative code.
Compared to it's own semantics, SQL is actually verbose, but its semantics is so powerful that you gain size.
- nojito 4y agoPlease share how many lines of sql it will take to statistically normalize multiple columns. Or even something simple like null cleaning columns based on dynamic thresholds.
- ontologiae 4y agoFor normalization, for instance : Select stddev(col1)/avg(col1), stddev(col2)/avg(col2),... from mytable group by key. One line.
- nojito 4y agoThat'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.