3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 Statement Executed
: Rows Affected
= 1
11 Statement Executed
: Rows Affected
= 1
12 Statement Executed
: Rows Affected
= 1
13 Statement Executed
: Rows Affected
= 1
14 Statement Executed
: Rows Affected
= 1
15 Statement Executed
: Rows Affected
= 1
16 Statement Executed
: Rows Affected
= 1
17 Statement Executed
: Rows Affected
= 1
18 Statement Executed
: Rows Affected
= 1
19 echo select * from t1
;
20 ---------------------------------------------------------
21 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
22 ---------------------------------------------------------
23 10 100 1000 Bijay
1000.000000 100000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
24 11 110 1100 Jitendr
2000.000000 200000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0
25 12 120 1000 Nihar
3000.000000 300000.000000 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0
26 13 130 NULL Kishor
4000.000000 400000.000000 2009/3/4 11:59:59.0 2009/3/4 11:59:59.0
27 14 100 1000 Praba
5000.000000 500000.000000 2009/3/1 11:59:58.0 2009/3/1 11:59:59.0
28 15 110 1100 Sanjit
6000.000000 600000.000000 2009/3/2 11:59:57.0 2009/3/2 11:59:59.0
29 16 120 1000 Sanjay NULL
700000.000000 2009/3/3 11:59:59.0 2009/3/3 11:59:59.0
30 17 130 1100 Arindam
8000.000000 800000.000000 2009/3/4 11:59:58.0 2009/3/4 11:59:59.0
31 10 100 1000 Bijay
9000.000000 900000.000000 2009/3/1 11:59:57.0 2009/3/1 11:59:59.0
32 11 NULL
1100 Jitendr
1000.000000 100000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0
33 12 120 1000 Nihar
2000.000000 200000.000000 2009/3/3 NULL
2009/3/3 11:59:59.0
34 13 130 1100 Kishor
3000.000000 300000.000000 2009/3/5 11:59:56.0 2009/3/5 11:59:59.0
35 14 100 1000 Praba
4000.000000 400000.000000 2009/3/1 11:59:55.0 2009/3/4 11:59:59.0
36 15 110 NULL Sanjit
5000.000000 500000.000000 2009/3/2 11:59:56.0 2009/3/1 11:59:59.0
37 16 120 1000 Sanjay
6000.000000 600000.000000 2009/3/3 11:59:55.0 2009/3/3 11:59:59.0
38 17 130 1100 Arindam
7000.000000 700000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
41 echo select f1
,f2
,f3
,f4
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 group by f1
,f2
,f3
,f4
;
42 ---------------------------------------------------------
43 f1 f2 f3 f4 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
44 ---------------------------------------------------------
45 10 100 1000 Bijay
2 10000.000000 2 1000000.000000
46 11 110 1100 Jitendr
1 2000.000000 1 200000.000000
47 12 120 1000 Nihar
2 5000.000000 2 500000.000000
48 13 130 NULL Kishor
1 4000.000000 1 400000.000000
49 14 100 1000 Praba
2 9000.000000 2 900000.000000
50 15 110 1100 Sanjit
1 6000.000000 1 600000.000000
51 16 120 1000 Sanjay
1 6000.000000 2 1300000.000000
52 17 130 1100 Arindam
2 15000.000000 2 1500000.000000
53 11 NULL
1100 Jitendr
1 1000.000000 1 100000.000000
54 13 130 1100 Kishor
1 3000.000000 1 300000.000000
55 15 110 NULL Sanjit
1 5000.000000 1 500000.000000
57 echo select f2
,f1
,f4
,f3
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 group by f1
,f2
,f3
,f4
;
58 ---------------------------------------------------------
59 f2 f1 f4 f3 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
60 ---------------------------------------------------------
61 100 10 Bijay
1000 2 10000.000000 2 1000000.000000
62 110 11 Jitendr
1100 1 2000.000000 1 200000.000000
63 120 12 Nihar
1000 2 5000.000000 2 500000.000000
64 130 13 Kishor NULL
1 4000.000000 1 400000.000000
65 100 14 Praba
1000 2 9000.000000 2 900000.000000
66 110 15 Sanjit
1100 1 6000.000000 1 600000.000000
67 120 16 Sanjay
1000 1 6000.000000 2 1300000.000000
68 130 17 Arindam
1100 2 15000.000000 2 1500000.000000
69 NULL
11 Jitendr
1100 1 1000.000000 1 100000.000000
70 130 13 Kishor
1100 1 3000.000000 1 300000.000000
71 110 15 Sanjit NULL
1 5000.000000 1 500000.000000
73 echo select f3
,f1
,f4
,f2
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 group by f1
,f2
,f3
,f4
;
74 ---------------------------------------------------------
75 f3 f1 f4 f2 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
76 ---------------------------------------------------------
77 1000 10 Bijay
100 2 10000.000000 2 1000000.000000
78 1100 11 Jitendr
110 1 2000.000000 1 200000.000000
79 1000 12 Nihar
120 2 5000.000000 2 500000.000000
80 NULL
13 Kishor
130 1 4000.000000 1 400000.000000
81 1000 14 Praba
100 2 9000.000000 2 900000.000000
82 1100 15 Sanjit
110 1 6000.000000 1 600000.000000
83 1000 16 Sanjay
120 1 6000.000000 2 1300000.000000
84 1100 17 Arindam
130 2 15000.000000 2 1500000.000000
85 1100 11 Jitendr NULL
1 1000.000000 1 100000.000000
86 1100 13 Kishor
130 1 3000.000000 1 300000.000000
87 NULL
15 Sanjit
110 1 5000.000000 1 500000.000000
89 echo select f4
,f3
,f2
,f1
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 group by f1
,f2
,f3
,f4
;
90 ---------------------------------------------------------
91 f4 f3 f2 f1 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
92 ---------------------------------------------------------
93 Bijay
1000 100 10 2 10000.000000 2 1000000.000000
94 Jitendr
1100 110 11 1 2000.000000 1 200000.000000
95 Nihar
1000 120 12 2 5000.000000 2 500000.000000
96 Kishor NULL
130 13 1 4000.000000 1 400000.000000
97 Praba
1000 100 14 2 9000.000000 2 900000.000000
98 Sanjit
1100 110 15 1 6000.000000 1 600000.000000
99 Sanjay
1000 120 16 1 6000.000000 2 1300000.000000
100 Arindam
1100 130 17 2 15000.000000 2 1500000.000000
101 Jitendr
1100 NULL
11 1 1000.000000 1 100000.000000
102 Kishor
1100 130 13 1 3000.000000 1 300000.000000
103 Sanjit NULL
110 15 1 5000.000000 1 500000.000000
105 echo select f1
,f2
,f3
,f4
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 group by f1
,f2
,f3
,f4 having
sum(f5
)>=5000;
106 ---------------------------------------------------------
107 f1 f2 f3 f4 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
108 ---------------------------------------------------------
109 10 100 1000 Bijay
2 10000.000000 2 1000000.000000
110 12 120 1000 Nihar
2 5000.000000 2 500000.000000
111 14 100 1000 Praba
2 9000.000000 2 900000.000000
112 15 110 1100 Sanjit
1 6000.000000 1 600000.000000
113 16 120 1000 Sanjay
1 6000.000000 2 1300000.000000
114 17 130 1100 Arindam
2 15000.000000 2 1500000.000000
115 15 110 NULL Sanjit
1 5000.000000 1 500000.000000
117 echo select f1
,f2
,f3
,f4
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 group by f1
,f2
,f3
,f4
;
118 ---------------------------------------------------------
119 f1 f2 f3 f4 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
120 ---------------------------------------------------------
121 12 120 1000 Nihar
2 5000.000000 2 500000.000000
122 13 130 NULL Kishor
1 4000.000000 1 400000.000000
123 14 100 1000 Praba
2 9000.000000 2 900000.000000
124 15 110 1100 Sanjit
1 6000.000000 1 600000.000000
125 16 120 1000 Sanjay
1 6000.000000 2 1300000.000000
126 17 130 1100 Arindam
2 15000.000000 2 1500000.000000
127 13 130 1100 Kishor
1 3000.000000 1 300000.000000
128 15 110 NULL Sanjit
1 5000.000000 1 500000.000000
130 echo select f4
,f3
,f1
,f2
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 group by f1
,f2
,f3
,f4
;
131 ---------------------------------------------------------
132 f4 f3 f1 f2 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
133 ---------------------------------------------------------
134 Nihar
1000 12 120 2 5000.000000 2 500000.000000
135 Kishor NULL
13 130 1 4000.000000 1 400000.000000
136 Praba
1000 14 100 2 9000.000000 2 900000.000000
137 Sanjit
1100 15 110 1 6000.000000 1 600000.000000
138 Sanjay
1000 16 120 1 6000.000000 2 1300000.000000
139 Arindam
1100 17 130 2 15000.000000 2 1500000.000000
140 Kishor
1100 13 130 1 3000.000000 1 300000.000000
141 Sanjit NULL
15 110 1 5000.000000 1 500000.000000
143 echo select f4
,f1
,f2
,f3
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 group by f1
,f2
,f3
,f4
;
144 ---------------------------------------------------------
145 f4 f1 f2 f3 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
146 ---------------------------------------------------------
147 Nihar
12 120 1000 2 5000.000000 2 500000.000000
148 Kishor
13 130 NULL
1 4000.000000 1 400000.000000
149 Praba
14 100 1000 2 9000.000000 2 900000.000000
150 Sanjit
15 110 1100 1 6000.000000 1 600000.000000
151 Sanjay
16 120 1000 1 6000.000000 2 1300000.000000
152 Arindam
17 130 1100 2 15000.000000 2 1500000.000000
153 Kishor
13 130 1100 1 3000.000000 1 300000.000000
154 Sanjit
15 110 NULL
1 5000.000000 1 500000.000000
156 echo select f4
,f3
,f1
,f2
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 group by f1
,f2
,f3
,f4
;
157 ---------------------------------------------------------
158 f4 f3 f1 f2 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
159 ---------------------------------------------------------
160 Nihar
1000 12 120 2 5000.000000 2 500000.000000
161 Kishor NULL
13 130 1 4000.000000 1 400000.000000
162 Praba
1000 14 100 2 9000.000000 2 900000.000000
163 Sanjit
1100 15 110 1 6000.000000 1 600000.000000
164 Sanjay
1000 16 120 1 6000.000000 2 1300000.000000
165 Arindam
1100 17 130 2 15000.000000 2 1500000.000000
166 Kishor
1100 13 130 1 3000.000000 1 300000.000000
167 Sanjit NULL
15 110 1 5000.000000 1 500000.000000
169 echo select f1
,f2
,f3
,f4
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f3
,f4
;
170 ---------------------------------------------------------
171 f1 f2 f3 f4 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
172 ---------------------------------------------------------
173 12 120 1000 Nihar
2 5000.000000 2 500000.000000
174 13 130 NULL Kishor
1 4000.000000 1 400000.000000
175 14 100 1000 Praba
2 9000.000000 2 900000.000000
176 13 130 1100 Kishor
1 3000.000000 1 300000.000000
178 echo select f2
,f3
,f4
,f1
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f3
,f4
;
179 ---------------------------------------------------------
180 f2 f3 f4 f1 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
181 ---------------------------------------------------------
182 120 1000 Nihar
12 2 5000.000000 2 500000.000000
183 130 NULL Kishor
13 1 4000.000000 1 400000.000000
184 100 1000 Praba
14 2 9000.000000 2 900000.000000
185 130 1100 Kishor
13 1 3000.000000 1 300000.000000
187 echo select f1
,f2
,f3
,f4
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f3
,f4
;
188 ---------------------------------------------------------
189 f1 f2 f3 f4 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
190 ---------------------------------------------------------
191 12 120 1000 Nihar
2 5000.000000 2 500000.000000
192 13 130 NULL Kishor
1 4000.000000 1 400000.000000
193 14 100 1000 Praba
2 9000.000000 2 900000.000000
194 13 130 1100 Kishor
1 3000.000000 1 300000.000000
196 echo select f1
,f2
,f3
,f4
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f3
,f4 having
sum(f5
)>=4000 and
sum(f5
)<6000;
197 ---------------------------------------------------------
198 f1 f2 f3 f4 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
199 ---------------------------------------------------------
200 12 120 1000 Nihar
2 5000.000000 2 500000.000000
201 13 130 NULL Kishor
1 4000.000000 1 400000.000000
203 echo select f1
,f2
,f3
,f4
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 and f2
<=130 group by f1
,f2
,f3
,f4
;
204 ---------------------------------------------------------
205 f1 f2 f3 f4 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
206 ---------------------------------------------------------
207 12 120 1000 Nihar
2 5000.000000 2 500000.000000
208 13 130 NULL Kishor
1 4000.000000 1 400000.000000
209 14 100 1000 Praba
2 9000.000000 2 900000.000000
210 15 110 1100 Sanjit
1 6000.000000 1 600000.000000
211 16 120 1000 Sanjay
1 6000.000000 2 1300000.000000
212 17 130 1100 Arindam
2 15000.000000 2 1500000.000000
213 13 130 1100 Kishor
1 3000.000000 1 300000.000000
214 15 110 NULL Sanjit
1 5000.000000 1 500000.000000
216 echo select f1
,f2
,f3
,f4
,count
(f5
),sum(f5
), count
(f6
),sum(f6
) from t1 where f1
>= 12 and f2
<=130 group by f1
,f2
,f3
,f4 having
sum(f5
)>=5000 and
sum(f5
)<10000;
217 ---------------------------------------------------------
218 f1 f2 f3 f4 COUNT
(f5
) SUM
(f5
) COUNT
(f6
) SUM
(f6
)
219 ---------------------------------------------------------
220 12 120 1000 Nihar
2 5000.000000 2 500000.000000
221 14 100 1000 Praba
2 9000.000000 2 900000.000000
222 15 110 1100 Sanjit
1 6000.000000 1 600000.000000
223 16 120 1000 Sanjay
1 6000.000000 2 1300000.000000
224 15 110 NULL Sanjit
1 5000.000000 1 500000.000000