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
),count
(f6
) from t1 group by f1
,f2
,f3
,f4
;
42 ---------------------------------------------------------
43 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
44 ---------------------------------------------------------
46 11 110 1100 Jitendr
1 1
48 13 130 NULL Kishor
1 1
50 15 110 1100 Sanjit
1 1
51 16 120 1000 Sanjay
1 2
52 17 130 1100 Arindam
2 2
53 11 NULL
1100 Jitendr
1 1
54 13 130 1100 Kishor
1 1
55 15 110 NULL Sanjit
1 1
57 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f2
,f1
,f4
,f3
;
58 ---------------------------------------------------------
59 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
60 ---------------------------------------------------------
62 11 110 1100 Jitendr
1 1
64 13 130 NULL Kishor
1 1
66 15 110 1100 Sanjit
1 1
67 16 120 1000 Sanjay
1 2
68 17 130 1100 Arindam
2 2
69 11 NULL
1100 Jitendr
1 1
70 13 130 1100 Kishor
1 1
71 15 110 NULL Sanjit
1 1
73 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f3
,f1
,f4
,f2
;
74 ---------------------------------------------------------
75 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
76 ---------------------------------------------------------
78 11 110 1100 Jitendr
1 1
80 13 130 NULL Kishor
1 1
82 15 110 1100 Sanjit
1 1
83 16 120 1000 Sanjay
1 2
84 17 130 1100 Arindam
2 2
85 11 NULL
1100 Jitendr
1 1
86 13 130 1100 Kishor
1 1
87 15 110 NULL Sanjit
1 1
89 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f4
,f3
,f2
,f1
;
90 ---------------------------------------------------------
91 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
92 ---------------------------------------------------------
94 11 110 1100 Jitendr
1 1
96 13 130 NULL Kishor
1 1
98 15 110 1100 Sanjit
1 1
99 16 120 1000 Sanjay
1 2
100 17 130 1100 Arindam
2 2
101 11 NULL
1100 Jitendr
1 1
102 13 130 1100 Kishor
1 1
103 15 110 NULL Sanjit
1 1
105 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f1
,f2
,f3
,f4 having count
(f5
)>=2;
106 ---------------------------------------------------------
107 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
108 ---------------------------------------------------------
109 10 100 1000 Bijay
2 2
110 12 120 1000 Nihar
2 2
111 14 100 1000 Praba
2 2
112 17 130 1100 Arindam
2 2
114 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 group by f1
,f2
,f3
,f4
;
115 ---------------------------------------------------------
116 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
117 ---------------------------------------------------------
118 12 120 1000 Nihar
2 2
119 13 130 NULL Kishor
1 1
120 14 100 1000 Praba
2 2
121 15 110 1100 Sanjit
1 1
122 16 120 1000 Sanjay
1 2
123 17 130 1100 Arindam
2 2
124 13 130 1100 Kishor
1 1
125 15 110 NULL Sanjit
1 1
127 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 group by f4
,f3
,f1
,f2
;
128 ---------------------------------------------------------
129 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
130 ---------------------------------------------------------
131 12 120 1000 Nihar
2 2
132 13 130 NULL Kishor
1 1
133 14 100 1000 Praba
2 2
134 15 110 1100 Sanjit
1 1
135 16 120 1000 Sanjay
1 2
136 17 130 1100 Arindam
2 2
137 13 130 1100 Kishor
1 1
138 15 110 NULL Sanjit
1 1
140 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 group by f4
,f1
,f2
,f3
;
141 ---------------------------------------------------------
142 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
143 ---------------------------------------------------------
144 12 120 1000 Nihar
2 2
145 13 130 NULL Kishor
1 1
146 14 100 1000 Praba
2 2
147 15 110 1100 Sanjit
1 1
148 16 120 1000 Sanjay
1 2
149 17 130 1100 Arindam
2 2
150 13 130 1100 Kishor
1 1
151 15 110 NULL Sanjit
1 1
153 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 group by f4
,f3
,f1
,f2
;
154 ---------------------------------------------------------
155 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
156 ---------------------------------------------------------
157 12 120 1000 Nihar
2 2
158 13 130 NULL Kishor
1 1
159 14 100 1000 Praba
2 2
160 15 110 1100 Sanjit
1 1
161 16 120 1000 Sanjay
1 2
162 17 130 1100 Arindam
2 2
163 13 130 1100 Kishor
1 1
164 15 110 NULL Sanjit
1 1
166 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f3
,f4
;
167 ---------------------------------------------------------
168 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
169 ---------------------------------------------------------
170 12 120 1000 Nihar
2 2
171 13 130 NULL Kishor
1 1
172 14 100 1000 Praba
2 2
173 13 130 1100 Kishor
1 1
175 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f1
<15 group by f2
,f3
,f4
,f1
;
176 ---------------------------------------------------------
177 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
178 ---------------------------------------------------------
179 12 120 1000 Nihar
2 2
180 13 130 NULL Kishor
1 1
181 14 100 1000 Praba
2 2
182 13 130 1100 Kishor
1 1
184 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f4
,f3
;
185 ---------------------------------------------------------
186 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
187 ---------------------------------------------------------
188 12 120 1000 Nihar
2 2
189 13 130 NULL Kishor
1 1
190 14 100 1000 Praba
2 2
191 13 130 1100 Kishor
1 1
193 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f3
,f4 having count
(f5
)>=0 and count
(f5
)<2;
194 ---------------------------------------------------------
195 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
196 ---------------------------------------------------------
197 13 130 NULL Kishor
1 1
198 13 130 1100 Kishor
1 1
200 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f2
<=130 group by f1
,f2
,f3
,f4
;
201 ---------------------------------------------------------
202 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
203 ---------------------------------------------------------
204 12 120 1000 Nihar
2 2
205 13 130 NULL Kishor
1 1
206 14 100 1000 Praba
2 2
207 15 110 1100 Sanjit
1 1
208 16 120 1000 Sanjay
1 2
209 17 130 1100 Arindam
2 2
210 13 130 1100 Kishor
1 1
211 15 110 NULL Sanjit
1 1
213 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f2
<=130 group by f1
,f2
,f3
,f4 having count
(f5
)>=0 and count
(f5
)<2;
214 ---------------------------------------------------------
215 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
216 ---------------------------------------------------------
217 13 130 NULL Kishor
1 1
218 15 110 1100 Sanjit
1 1
219 16 120 1000 Sanjay
1 2
220 13 130 1100 Kishor
1 1
221 15 110 NULL Sanjit
1 1