s**n
发帖数: 178 | 1 The query:
Table t schema:
(a1 int, a2 char(10), a3 varchar(10))
select a2, sum(2) from t group by a2; | B*****g
发帖数: 34098 | 2 2+2+2+.....+2
【在 s**n 的大作中提到】
: The query:
: Table t schema:
: (a1 int, a2 char(10), a3 varchar(10))
: select a2, sum(2) from t group by a2;
| y*****g
发帖数: 677 | 3 yeah,
probably 2*n, n is the number of entries in each group of a2. | s**n
发帖数: 178 | 4
This is correct. But I can not find it in SQL document.
【在 y*****g 的大作中提到】
: yeah,
: probably 2*n, n is the number of entries in each group of a2.
| y****w
发帖数: 3747 | 5 sql server？ 这个很不relational.
【在 s**n 的大作中提到】
:
: This is correct. But I can not find it in SQL document.
|
|
