What is the practical meaning of arranging the DISTINCT keyword this way? DISTINCT is just an attribute of the select list (= column1, column2). If we put it left then it would rather look like a clause.
The actual positioning of the DISTINCT keyword is less important to me in that it coudl be after the select. Thats not an issue. I just don’t like where the selected columns are positioned.
So for example I have no issue with below:
select distinct
column1,
column2
from
dual
However the formatter would still position the columns to the right of the distinct attribute like below:
select distinct column1,
column2
from
dual
I would prefer it to create a new line for the columns rather than starting way off to the right like above.