Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. id number
  2. 0 4000
  3. 1 2000
  4. 2 4000
  5. 3 5000
  6.  
  7. SELECT SUM(number) FROM yourTable WHERE id BETWEEN 0 AND 2
  8.  
  9. SELECT SUM(number) FROM your_table WHERE id BETWEEN 0 and 2;
  10.  
  11. SELECT id, SUM(number) FROM your_table WHERE id BETWEEN 0 and 2
  12. group by id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement