Guest User

Untitled

a guest
Jul 17th, 2018
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. +------------+---------+
  2. | name | value |
  3. +------------+---------+
  4. | parameter1 | 53.8462 |
  5. | parameter2 | 7.6923 |
  6. | parameter3 | 23.0769 |
  7. | parameter4 | 15.3846 |
  8. +------------+---------+
  9.  
  10. WITH OrderedRows AS
  11. (
  12. SELECT name, value,
  13. ROW_NUMBER() OVER (ORDER BY name) AS 'RowNumber'
  14. FROM table
  15. )
  16. SELECT sum(value)
  17. FROM OrderedRows
  18. WHERE RowNumber > 1;
  19.  
  20. SELECT SUM(value) tot
  21. FROM table
  22. WHERE name='parameter2' OR name='parameter3' OR name='parameter4'
  23.  
  24. SELECT SUM(value) tot
  25. FROM table
  26. WHERE name<>'parameter1'
  27.  
  28. select sum(value) from values where name!='parameter1';
  29.  
  30. SELECT SUM(value) tot
  31. FROM table
  32. WHERE name<>'parameter1'
  33.  
  34. SELECT SUM(coalesce(value, 0)) your_total
  35. FROM table
  36. WHERE coalesce(name, '') <> 'parameter1'
Add Comment
Please, Sign In to add comment