81,092
社区成员
发帖
与我相关
我的任务
分享
select name from
(select name from student order by flushdate)
group by name
1 10000540
2 10000541
3 218
4 220
5 225
6 415
7 429
8 432
9 434
10 443
11 455
12 472
13 473
14 474
15 127
16 129
17 130
18 1
19 45
20 47
21 55
1 218
2 220
3 225
4 231
5 415
6 429
7 432
8 434
9 441
10 443
11 455
12 472
13 473
14 474
15 10000540
16 10000541
17 127
18 129
19 130
20 1
21 45
select y0_ from (
select
this_.CCCW10 as y0_
from
CCW1 this_
left outer join
CCW2 ccw2x1_
on this_.CCCW10=ccw2x1_.cccw10
left outer join
CCW3 ccw3x2_
on this_.CCCW10=ccw3x2_.cccw10
left outer join
CCW4 ccw4x3_
on this_.CCCW10=ccw4x3_.cccw10
order by this_.AAE136
)
group by y0_
;
select
this_.CCCW10 as y0_
from
CCW1 this_
left outer join
CCW2 ccw2x1_
on this_.CCCW10=ccw2x1_.cccw10
left outer join
CCW3 ccw3x2_
on this_.CCCW10=ccw3x2_.cccw10
left outer join
CCW4 ccw4x3_
on this_.CCCW10=ccw4x3_.cccw10
group by this_.CCCW10