Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT jml_antri_hits, jml_sudah_hits FROM
- (SELECT tgl_hits, COUNT(*) AS jml_antri_hits FROM WS_CEK_NIK WHERE flag_nik IS NULL AND tgl_hits = CONVERT(VARCHAR(10), getdate(), 111)
- GROUP BY tgl_hits)
- a INNER JOIN
- (SELECT tgl_hits, COUNT(*) AS jml_sudah_hits FROM WS_CEK_NIK WHERE flag_nik IS NOT NULL AND tgl_hits = CONVERT(VARCHAR(10), getdate(), 111)
- GROUP BY tgl_hits)
- b ON a.tgl_hits = b.tgl_hits
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement