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 strongm 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 pezzypezpez
-
Breaking ties when using max(date)
Thanks for the quick response. These are both very good questions, and I hope I can answer them. First, I have been told by the DB2 analysts I have working on this say that this is not the case. They say the date function returns a set of values and then DB2 picks the max one, but if there...- pezzypezpez
- Post #3
- Forum: IBM: DB2
-
Breaking ties when using max(date)
I am trying to find information on how DB2 (and Informix, since we are switching from Informix to DB2) breaks ties and returns data using the following type of select statement: select max(date(claim_status_hist.claim_status_dt)) from claim_status_hist where claim_status_cd = 1; The specific...- pezzypezpez
- Thread
- Replies: 5
- Forum: IBM: DB2
