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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by schauncey
-
DB2 SQL Group By on Year(DATE)
I have the following Select Statement<br><br>Select BLACCT, Sum(BLTOTQ) as sumofBLTOTQ, Sum(BLTOTW) as sumofBLTOTW, Count(BLACCT) as countofBLACCT, BLRECN, sum(BLSLAM) as sumofBLSLAM, sum(BLPAID) as sumofBLPAID, <br>YEAR(BLSHYY) From ttcdd.EDIBOLDB Where (Year(BLSHYY) >= 2000 and Year(BLSHYY)...
