SQL & PL/SQL

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!

query for same sum(field) on two different criteria

user543625Nov 20 2006 — edited Nov 24 2006

I want to sum a field in two different criterias in a single query like

sum(Debit),sum(credit)
criteria 1) for Date < input date
criterie 2) for Date > input date

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2006

Added on Nov 20 2006

17 comments

560 views