You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Group clauses and order clauses have an affinity with select clauses, so they often copy the contents of the select clause.
There's no point in giving an alias to an order clause, but it's a hassle to correct it, so I think coding will be easier if they're ignored.
Note that the columns that can be specified are limited to columns that belong to formulas or tables, and the currently selected column cannot be specified (same as normal SQL).
To be specific, we should state that "sum(a.price) as total_price" cannot be written as "order by total_price".
The reason is that refactoring will not work.
The text was updated successfully, but these errors were encountered:
Group clauses and order clauses have an affinity with select clauses, so they often copy the contents of the select clause.
There's no point in giving an alias to an order clause, but it's a hassle to correct it, so I think coding will be easier if they're ignored.
Note that the columns that can be specified are limited to columns that belong to formulas or tables, and the currently selected column cannot be specified (same as normal SQL).
To be specific, we should state that "sum(a.price) as total_price" cannot be written as "order by total_price".
The reason is that refactoring will not work.
The text was updated successfully, but these errors were encountered: