How to SELECT sum of numbers less than 30 and sum of numbers greater than 30? How to SELECT sum of numbers less than 30 and sum of numbers greater than 30? oracle oracle

How to SELECT sum of numbers less than 30 and sum of numbers greater than 30?


sql oracle teradata

Something along these lines (correct the syntax for your environment):

SELECT    sum(case when Field < 30 then Field else 0 end) as LessThan30,    sum(case when Field > 30 then Field else 0 end) as MoreThan30FROM    DaTable

sql oracle teradata

The requirement is a big vague, but I'll assume SUM across rows and <> 30. This is different to the case answer.

SELECT    SelectCol1, SelectCol2, SelectCol3, ..., SUM(AggregateCol)FROM    TableGROUP BY    SelectCol1, SelectCol2, SelectCol3, ...HAVING    SUM(AggregateCol) <> 30

sql oracle teradata

If i understand correctly, you have a single column which has numeric values and you want to find sum of this field for all thw rows where the field value is less than 30 and same condition with the variation of field value greater than 30. If this is correct, then you can use the below query and replcae the table and column name accordingly. 

SELECT  SUM(CASE        WHEN col1 < 30 THEN COL1        ELSE 0 END       )    SUM(CASE        WHEN col1 < 30 THEN COL1        ELSE 0 END       ) FROM   DATABASE.SCHEMANAME.TABLE

Thanks,Atul

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last