Advertisement
Guest User

Untitled

a guest
Jul 29th, 2017
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.17 KB | None | 0 0
  1. select count(fixed) as votes
  2. from fixed d
  3. group by fixed
  4. having fixed=1
  5. union all
  6. select count(fixed) as votes
  7. from fixed d
  8. group by fixed
  9. having fixed=0
  10.  
  11. [votes]
  12. 4
  13. 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement