Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get all records which has sum of two columns is zero or other

2964511Jun 3 2015 — edited Jun 4 2015

Hi Experts,

I am trying to write an SQL Query to get all the records which has sum of two column equal to 0 with where condition.

Need to write and SQL with following constraints.

T1 Table:

Group by name

Sum of fine with type = F

Sum fine with type = S

Subtract S total  from F total for each name will be my total due.

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2015
Added on Jun 3 2015
#sql, #sql-developer
2 comments
601 views