2 Statement Executed
: Rows Affected
= 1
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 echo select * from t1
;
19 ---------------------------------------------------------
20 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
21 ---------------------------------------------------------
22 10 100 1000 Bijay
1000.000000 100000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
23 11 110 1100 Jitendr
2000.000000 200000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0
24 12 120 1000 Nihar
3000.000000 300000.000000 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0
25 13 130 NULL Kishor
4000.000000 400000.000000 2009/3/4 11:59:59.0 2009/3/4 11:59:59.0
26 14 100 1000 Praba
5000.000000 500000.000000 2009/3/1 11:59:58.0 2009/3/1 11:59:59.0
27 15 110 1100 Sanjit
6000.000000 600000.000000 2009/3/2 11:59:57.0 2009/3/2 11:59:59.0
28 16 120 1000 Sanjay NULL
700000.000000 2009/3/3 11:59:59.0 2009/3/3 11:59:59.0
29 17 130 1100 Arindam
8000.000000 800000.000000 2009/3/4 11:59:58.0 2009/3/4 11:59:59.0
30 10 100 1000 Bijay
9000.000000 900000.000000 2009/3/1 11:59:57.0 2009/3/1 11:59:59.0
31 11 NULL
1100 Jitendr
1000.000000 100000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0
32 12 120 1000 Nihar
2000.000000 200000.000000 2009/3/3 NULL
2009/3/3 11:59:59.0
33 13 130 1100 Kishor
3000.000000 300000.000000 2009/3/5 11:59:56.0 2009/3/5 11:59:59.0
34 14 100 1000 Praba
4000.000000 400000.000000 2009/3/1 11:59:55.0 2009/3/4 11:59:59.0
35 15 110 NULL Sanjit
5000.000000 500000.000000 2009/3/2 11:59:56.0 2009/3/1 11:59:59.0
36 16 120 1000 Sanjay
6000.000000 600000.000000 2009/3/3 11:59:55.0 2009/3/3 11:59:59.0
37 17 130 1100 Arindam
7000.000000 700000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
39 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f1
,f2
,f3
,f4
;
40 ---------------------------------------------------------
41 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
42 ---------------------------------------------------------
44 11 110 1100 Jitendr
1 1
46 13 130 NULL Kishor
1 1
48 15 110 1100 Sanjit
1 1
49 16 120 1000 Sanjay
1 2
50 17 130 1100 Arindam
2 2
51 11 NULL
1100 Jitendr
1 1
52 13 130 1100 Kishor
1 1
53 15 110 NULL Sanjit
1 1
55 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f2
,f1
,f4
,f3
;
56 ---------------------------------------------------------
57 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
58 ---------------------------------------------------------
60 11 110 1100 Jitendr
1 1
62 13 130 NULL Kishor
1 1
64 15 110 1100 Sanjit
1 1
65 16 120 1000 Sanjay
1 2
66 17 130 1100 Arindam
2 2
67 11 NULL
1100 Jitendr
1 1
68 13 130 1100 Kishor
1 1
69 15 110 NULL Sanjit
1 1
71 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f3
,f1
,f4
,f2
;
72 ---------------------------------------------------------
73 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
74 ---------------------------------------------------------
76 11 110 1100 Jitendr
1 1
78 13 130 NULL Kishor
1 1
80 15 110 1100 Sanjit
1 1
81 16 120 1000 Sanjay
1 2
82 17 130 1100 Arindam
2 2
83 11 NULL
1100 Jitendr
1 1
84 13 130 1100 Kishor
1 1
85 15 110 NULL Sanjit
1 1
87 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f4
,f3
,f2
,f1
;
88 ---------------------------------------------------------
89 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
90 ---------------------------------------------------------
92 11 110 1100 Jitendr
1 1
94 13 130 NULL Kishor
1 1
96 15 110 1100 Sanjit
1 1
97 16 120 1000 Sanjay
1 2
98 17 130 1100 Arindam
2 2
99 11 NULL
1100 Jitendr
1 1
100 13 130 1100 Kishor
1 1
101 15 110 NULL Sanjit
1 1
103 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 group by f1
,f2
,f3
,f4 having count
(f5
)>=2;
104 ---------------------------------------------------------
105 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
106 ---------------------------------------------------------
107 10 100 1000 Bijay
2 2
108 12 120 1000 Nihar
2 2
109 14 100 1000 Praba
2 2
110 17 130 1100 Arindam
2 2
112 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 group by f1
,f2
,f3
,f4
;
113 ---------------------------------------------------------
114 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
115 ---------------------------------------------------------
116 12 120 1000 Nihar
2 2
117 13 130 NULL Kishor
1 1
118 14 100 1000 Praba
2 2
119 15 110 1100 Sanjit
1 1
120 16 120 1000 Sanjay
1 2
121 17 130 1100 Arindam
2 2
122 13 130 1100 Kishor
1 1
123 15 110 NULL Sanjit
1 1
125 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 group by f4
,f3
,f1
,f2
;
126 ---------------------------------------------------------
127 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
128 ---------------------------------------------------------
129 12 120 1000 Nihar
2 2
130 13 130 NULL Kishor
1 1
131 14 100 1000 Praba
2 2
132 15 110 1100 Sanjit
1 1
133 16 120 1000 Sanjay
1 2
134 17 130 1100 Arindam
2 2
135 13 130 1100 Kishor
1 1
136 15 110 NULL Sanjit
1 1
138 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 group by f4
,f1
,f2
,f3
;
139 ---------------------------------------------------------
140 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
141 ---------------------------------------------------------
142 12 120 1000 Nihar
2 2
143 13 130 NULL Kishor
1 1
144 14 100 1000 Praba
2 2
145 15 110 1100 Sanjit
1 1
146 16 120 1000 Sanjay
1 2
147 17 130 1100 Arindam
2 2
148 13 130 1100 Kishor
1 1
149 15 110 NULL Sanjit
1 1
151 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 group by f4
,f3
,f1
,f2
;
152 ---------------------------------------------------------
153 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
154 ---------------------------------------------------------
155 12 120 1000 Nihar
2 2
156 13 130 NULL Kishor
1 1
157 14 100 1000 Praba
2 2
158 15 110 1100 Sanjit
1 1
159 16 120 1000 Sanjay
1 2
160 17 130 1100 Arindam
2 2
161 13 130 1100 Kishor
1 1
162 15 110 NULL Sanjit
1 1
164 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f3
,f4
;
165 ---------------------------------------------------------
166 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
167 ---------------------------------------------------------
168 12 120 1000 Nihar
2 2
169 13 130 NULL Kishor
1 1
170 14 100 1000 Praba
2 2
171 13 130 1100 Kishor
1 1
173 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f1
<15 group by f2
,f3
,f4
,f1
;
174 ---------------------------------------------------------
175 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
176 ---------------------------------------------------------
177 12 120 1000 Nihar
2 2
178 13 130 NULL Kishor
1 1
179 14 100 1000 Praba
2 2
180 13 130 1100 Kishor
1 1
182 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f1
<15 group by f1
,f2
,f4
,f3
;
183 ---------------------------------------------------------
184 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
185 ---------------------------------------------------------
186 12 120 1000 Nihar
2 2
187 13 130 NULL Kishor
1 1
188 14 100 1000 Praba
2 2
189 13 130 1100 Kishor
1 1
191 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;
192 ---------------------------------------------------------
193 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
194 ---------------------------------------------------------
195 13 130 NULL Kishor
1 1
196 13 130 1100 Kishor
1 1
198 echo select f1
,f2
,f3
,f4
,count
(f5
),count
(f6
) from t1 where f1
>= 12 and f2
<=130 group by f1
,f2
,f3
,f4
;
199 ---------------------------------------------------------
200 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
201 ---------------------------------------------------------
202 12 120 1000 Nihar
2 2
203 13 130 NULL Kishor
1 1
204 14 100 1000 Praba
2 2
205 15 110 1100 Sanjit
1 1
206 16 120 1000 Sanjay
1 2
207 17 130 1100 Arindam
2 2
208 13 130 1100 Kishor
1 1
209 15 110 NULL Sanjit
1 1
211 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;
212 ---------------------------------------------------------
213 f1 f2 f3 f4 COUNT
(f5
) COUNT
(f6
)
214 ---------------------------------------------------------
215 13 130 NULL Kishor
1 1
216 15 110 1100 Sanjit
1 1
217 16 120 1000 Sanjay
1 2
218 13 130 1100 Kishor
1 1
219 15 110 NULL Sanjit
1 1