Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(items > 0) as totalItems FROM testTable
- Incorrect syntax near '>'.
- SELECT SUM(CASE WHEN items > 0 THEN 1 ELSE 0 END) as totalItems
- FROM testTable;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement