Group by 'string' clause
This form can be output in Oracle, equivalent to not group
The but there are other special meaning???????

CodePudding user response:

For example,
# the select * from tt;
A | B |
- + -- -- --
1 | 3 |
2 | | 4

=# select sum (a) the from tt group by 'adgf;
The SUM
-- -- -- -- --
9

CodePudding user response:

Kindness and no group by 'adgf; Different execution plan is a little small

The building Lord might as well try

CodePudding user response:

refer to the second floor u012557814 response:

add and add group by 'adgf; Different execution plan is a little small

The building Lord try

This does not effect the
SQL> Select sum (a) the from tt1.

The SUM (A)
-- -- -- -- -- -- -- -- -- --
6

SQL> Select sum (a) the from tt1 group by 'adgv';

The SUM (A)
-- -- -- -- -- -- -- -- -- --
6