MVSFORUMS.com A Community of and for MVS Professionals    FAQ   Search   Quick Manuals   Register   Profile   Log in to check your private messages   Log in  Search found 1 match MVSFORUMS.com Forum Index Author Message   Topic: Eliminating Duplicates - DB2 Query abalan76 Replies: 6 Views: 2486 Forum: Database   Posted: Fri Jul 01, 2005 4:59 am   Subject: Eliminating Duplicates - DB2 Query Sakreg, Can you try this First post , haven't tested it SELECT * FROM TABLE A WHERE EFF_DT = (SELECT MAX(EFF_DT) FROM TABLE B ...   Page 1 of 1 All times are GMT - 5 Hours Jump to: Select a forum Announcements----------------MVSFORUMS - Announcements Help Boards----------------Application ProgrammingDatabaseUtilitiesJob Control Language(JCL)CICS and MiddlewareIMSTSO and ISPFData ManagementProblem DeterminationMainframe ChallengeAbout MvsforumsOther Technical TopicsRelated Non-Technical TopicsInterview Q & A General----------------Tools and DownloadsIT News Technical FAQ (Tips)----------------Programming LanguagesDB2/IMSJCL/SORTTSO and ISPF  MVSFORUMS Powered by phpBB © 2001, 2005 phpBB Group