|
|
ลำดับ |
อายุ |
จำนวน |
select 'น้อยกว่า 25 ปี' t1, (select count (*) from vw_person_age where age <= 25 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu')) r1, '26 - 30 ปี' t2, (select count (*) from vw_person_age where age between 26 and 30 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu')) r2, '31 - 35 ปี' t3, (select count (*) from vw_person_age where age between 31 and 35 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu')) r3, '36 - 40 ปี' t4, (select count (*) from vw_person_age where age between 36 and 40 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu')) r4, '41 - 45 ปี' t5, (select count (*) from vw_person_age where age between 41 and 45 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu')) r5, '46 - 50 ปี' t6, (select count (*) from vw_person_age where age between 46 and 50 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu')) r6, '51 - 55 ปี' t7, (select count (*) from vw_person_age where age between 51 and 55 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu')) r7, '56 - 60 ปี' t8, (select count (*) from vw_person_age where age between 56 and 60 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu')) r8, 'มากกว่า 60 ปี' t9, (select count (*) from vw_person_age where age > 60 and person_type_code = '$Tch$' and(person_subtype='Current' or person_subtype='Edu' )) r9 from dual
|
1 |
น้อยกว่า 25 ปี |
0 |
|
2 |
26 - 30 ปี |
0 |
|
3 |
31 - 35 ปี |
0 |
|
4 |
36 - 40 ปี |
0 |
|
5 |
41 - 45 ปี |
0 |
|
6 |
46 - 50 ปี |
5 |
|
7 |
51 - 55 ปี |
32 |
|
8 |
56 - 60 ปี |
32 |
|
9 |
มากกว่า 60 ปี |
3 |
|
|
จำนวนบุคลากร 72 คน |
72 |
|
จำนวน 9 รายการ |
ข้อมูล ณ วันที่ 25/10/2569
|
|
| |