Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- (select count(1) from alerts) as Total,
- (select count(1) from alerts where iscomplete is null or iscomplete = 0) as Active,
- (select count(1) from alerts where iscomplete = 1) as Complete
Add Comment
Please, Sign In to add comment