Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +------------+---------+
- | name | value |
- +------------+---------+
- | parameter1 | 53.8462 |
- | parameter2 | 7.6923 |
- | parameter3 | 23.0769 |
- | parameter4 | 15.3846 |
- +------------+---------+
- WITH OrderedRows AS
- (
- SELECT name, value,
- ROW_NUMBER() OVER (ORDER BY name) AS 'RowNumber'
- FROM table
- )
- SELECT sum(value)
- FROM OrderedRows
- WHERE RowNumber > 1;
- SELECT SUM(value) tot
- FROM table
- WHERE name='parameter2' OR name='parameter3' OR name='parameter4'
- SELECT SUM(value) tot
- FROM table
- WHERE name<>'parameter1'
- select sum(value) from values where name!='parameter1';
- SELECT SUM(value) tot
- FROM table
- WHERE name<>'parameter1'
- SELECT SUM(coalesce(value, 0)) your_total
- FROM table
- WHERE coalesce(name, '') <> 'parameter1'
Add Comment
Please, Sign In to add comment