Guest User

Untitled

a guest
Nov 19th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. select
  2. (select count(1) from alerts) as Total,
  3. (select count(1) from alerts where iscomplete is null or iscomplete = 0) as Active,
  4. (select count(1) from alerts where iscomplete = 1) as Complete
Add Comment
Please, Sign In to add comment