Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT dun, COUNT( id_ahli ) AS JUMLAH_KESELURUHAN, COUNT(kaum='melayu') AS melayu, COUNT(kaum='cina') AS cina
- FROM maklumat_ahli
- WHERE jantina = 'lelaki'
- AND
- (kematian_tarikh IS NULL)
- AND (bayaran_pertama IS NULL)
- AND (bayaran_kedua IS NULL)
- GROUP BY dun
- ORDER BY dun
- /-----------------------------------------/
- |dun | Jumlah_keseluruhan | melayu | cina |
- -------------------------------------------
- |A |123 |100 |23 |
- -------------------------------------------
- COUNT(case when kaum='melayu' then 1 else 0 end) AS melayu,
- COUNT(case when kaum='cina'the 1 else 0 end) AS cina
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement