Advertisement
Guest User

Untitled

a guest
May 22nd, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.40 KB | None | 0 0
  1. SELECT jml_antri_hits, jml_sudah_hits FROM
  2. (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)
  3. GROUP BY tgl_hits)
  4.  a  INNER JOIN
  5. (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)
  6. GROUP BY tgl_hits)
  7. b ON a.tgl_hits = b.tgl_hits
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement