func_group.result
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:1k
- a c sum(a)
- 1 a 1
- 2 b 2
- 3 c 3
- 4 E 4
- 5 C 5
- 6 D 6
- a c sum(a)
- sum(a)
- NULL
- a
- 1
- 3
- 6
- 5
- 2
- 4
- a
- 1
- 3
- 6
- 5
- 2
- 4
- count(distinct a) count(distinct grp)
- 6 3
- count(distinct a) count(distinct grp)
- 6 3
- sum(a) count(a) avg(a) std(a) bit_or(a) bit_and(a) min(a) max(a) min(c) max(c)
- 21 6 3.5000 1.7078 7 0 1 6 E
- grp sum(a) count(a) avg(a) std(a) bit_or(a) bit_and(a) min(a) max(a) min(c) max(c)
- NULL 0 0 NULL NULL 0 0 NULL NULL
- 1 1 1 1.0000 0.0000 1 1 1 1 a a
- 2 5 2 2.5000 0.5000 3 2 2 3 b c
- 3 15 3 5.0000 0.8165 7 4 4 6 C E
- grp sum
- NULL NULL
- 1 7
- 2 20
- 3 44.816496580928
- grp a c
- NULL NULL
- 1 2 a
- 2 5 c
- 3 9 E
- 2 3 c
- id avg(value1) std(value1)
- 1 1.000000 0.816497
- 2 11.000000 0.816497
- name avg(value1) std(value1)
- Set One 1.000000 0.816497
- Set Two 11.000000 0.816497
- id avg(rating)
- 1 3.0000
- 2 NULL
- 3 2.0000
- count(*)
- 3
- count(*)
- 1
- count(*)
- 0
- count(*)
- 0
- count(a)
- 1
- count(a)
- 0
- count(a)
- 0
- count(b)
- 2
- count(b)
- 0
- count(c)
- 0
- COUNT(i) i COUNT(i)*i
- 1 1 1
- COUNT(i) (i+0) COUNT(i)*(i+0)
- 1 1 1
- sum(num)
- 147.58
- sum(num)
- 50.15
- 45.63
- 51.80