daily pastebin goal
38%
SHARE
TWEET

Untitled

a guest Dec 13th, 2018 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. TABLE1:
  2.     A  |  B  |  C  
  3. ---------------------
  4.     1  |  9  |  0
  5.     2  |  7  |  0
  6.     4  |  8  |  0
  7.     3  |  6  |  0
  8.    
  9. TABLE1:
  10.     A  |  B  |  C  
  11. ---------------------
  12.     1  |  9  |  0.25
  13.     2  |  7  |  0.25
  14.     4  |  8  |  0.25
  15.     3  |  6  |  0.25
  16.    
  17. UPDATE TABLE
  18. SET C = 1/COUNT(*)
  19.    
  20. Error: ERROR: aggregate functions are not allowed in UPDATE
  21. Position: 21
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top