Advertisement
Guest User

Untitled

a guest
Jul 30th, 2014
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. count(*), count(0), count(1), count(-1)
  2.  
  3. select count(ALL 1/0) from xyz; -- Succeeds
  4.  
  5. select count(DISTINCT 1/0) from xyz; -- Divide by Zero
  6.  
  7. select count(1) from xyz; -- Operand data type void type is invalid for count operator.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement