Category

Development Platform
Home > SourceCode/Document > Database system > MySQL > View Code
func_group.result
Package: mysql-3.23.35.tar.gz　[view]
Upload User: tsgydb
Upload Date: 2007-04-14
Package Size: 10674k
Code Size: 1k
Category:

MySQL

Development Platform:

Visual C++

func_group.result：Code Content
  1. a c sum(a)
  2. 1 a 1
  3. 2 b 2
  4. 3 c 3
  5. 4 E 4
  6. 5 C 5
  7. 6 D 6
  8. a c sum(a)
  9. sum(a)
  10. NULL
  11. a
  12. 1
  13. 3
  14. 6
  15. 5
  16. 2
  17. 4
  18. a
  19. 1
  20. 3
  21. 6
  22. 5
  23. 2
  24. 4
  25. count(distinct a) count(distinct grp)
  26. 6 3
  27. count(distinct a) count(distinct grp)
  28. 6 3
  29. sum(a) count(a) avg(a) std(a) bit_or(a) bit_and(a) min(a) max(a) min(c) max(c)
  30. 21 6 3.5000 1.7078 7 0 1 6 E
  31. grp sum(a) count(a) avg(a) std(a) bit_or(a) bit_and(a) min(a) max(a) min(c) max(c)
  32. NULL 0 0 NULL NULL 0 0 NULL NULL
  33. 1 1 1 1.0000 0.0000 1 1 1 1 a a
  34. 2 5 2 2.5000 0.5000 3 2 2 3 b c
  35. 3 15 3 5.0000 0.8165 7 4 4 6 C E
  36. grp sum
  37. NULL NULL
  38. 1 7
  39. 2 20
  40. 3 44.816496580928
  41. grp a c
  42. NULL NULL
  43. 1 2 a
  44. 2 5 c
  45. 3 9 E
  46. 2 3 c
  47. id avg(value1) std(value1)
  48. 1 1.000000 0.816497
  49. 2 11.000000 0.816497
  50. name avg(value1) std(value1)
  51. Set One 1.000000 0.816497
  52. Set Two 11.000000 0.816497
  53. id avg(rating)
  54. 1 3.0000
  55. 2 NULL
  56. 3 2.0000
  57. count(*)
  58. 3
  59. count(*)
  60. 1
  61. count(*)
  62. 0
  63. count(*)
  64. 0
  65. count(a)
  66. 1
  67. count(a)
  68. 0
  69. count(a)
  70. 0
  71. count(b)
  72. 2
  73. count(b)
  74. 0
  75. count(c)
  76. 0
  77. COUNT(i) i COUNT(i)*i
  78. 1 1 1
  79. COUNT(i) (i+0) COUNT(i)*(i+0)
  80. 1 1 1
  81. sum(num)
  82. 147.58
  83. sum(num)
  84. 50.15
  85. 45.63
  86. 51.80