|
So if I run this select * from qtemp/srcmbrhash order by shh_lib, shh_file, shh_member, shh_lcdate desc, shh_lctime desc And get ....+....1....+....2....+....3....+....4....+....5....+....6....+....7 SHH_LIB SHH_FILE SHH_MEMBER SHH_LCDATE SHH_LCTIME SHH_HASH MYLIB MYFILE MYMBR 2006-06-14 13:20:14 X347 MYLIB MYFILE MYMBR 2006-06-11 15:20:14 X342 ******** End of data ******** You want select * from qtemp/srcmbrhash where (shh_lib, shh_file, shh_member, timestamp(shh_lcdate, shh_lctime)) in (select shh_lib, shh_file, shh_member, max(timestamp(shh_lcdate, shh_lctime)) from qtemp/srcmbrhash group by shh_lib, shh_file, shh_member) ....+....1....+....2....+....3....+....4....+....5....+....6....+....7 SHH_LIB SHH_FILE SHH_MEMBER SHH_LCDATE SHH_LCTIME SHH_HASH MYLIB MYFILE MYMBR 2006-06-14 13:20:14 X347 ******** End of data ******** Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.