 |
ขอทราบวิธีการ COUNT ข้อมูลแบบ SUBSTRING โดยมีข้อมูลอยู่ในฟิลเดียว |
| |
 |
|
|
 |
 |
|
Code (SQL)
#MySql
select
sum( if( UserDefine1 = '07:30 - 19:00', 1, 0)) as `07:30-19:00`
, sum( if( UserDefine1 = '19:00 - 06:30', 1, 0)) as `19:00-06:30`
from .....
where .....
#MsSql
select
sum( iif( UserDefine1 = '07:30 - 19:00', 1, 0)) as "07:30-19:00"
, sum( iif( UserDefine1 = '19:00 - 06:30', 1, 0)) as "19:00-06:30"
from .....
where .....
|
ประวัติการแก้ไข
2020-01-29 21:36:39
2020-01-29 21:39:31
 |
 |
 |
 |
| Date :
2020-01-25 12:51:08 |
By :
Chaidhanan |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ขอญาตเพิ่มเติมครับ
Code (SQL)
select
count( case when UserDefine1 = '07:30 - 19:00' then 1 end ) as `07:30-19:00`
, count( case when UserDefine1 = '19:00 - 06:30' then 1 end ) as `19:00-06:30`
from .....
where .....
หรือ
Code (SQL)
select
count( case when UserDefine1 = '07:30 - 19:00' then 1 else null end ) as `07:30-19:00`
, count( case when UserDefine1 = '19:00 - 06:30' then 1 else null end ) as `19:00-06:30`
from .....
where .....
|
| |
|
|
| |
| Date :
2020-01-29 16:07:53 |
By :
WWWWIN |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
