Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: csphillips6
- Order by date
-
Aggregate in Oracle 8
SELECT blcat.rpdesc, blbhst.bankno, blbhst.bkname, sum(blhst.charge) FROM blcat, bldhst, blhst, blbhst WHERE blcat.bilcat = bldhst.bilcat and bldhst.appl = blhst.appl and bldhst.subcd = blhst.subcd and blhst.bankno = blbhst.bankno and blhst.seq =...- csphillips6
- Post #3
- Forum: Oracle: All versions
-
Aggregate in Oracle 8
I'm a new position with a company that uses Oracle 8 after work on on SQL Server 2000 for years. I'm working on a report where I have to sum a table field (charge) for each row and the sum will be an aggregate based on a billing code in another table. I would use a sub-query expression for...- csphillips6
- Thread
- Replies: 3
- Forum: Oracle: All versions
