MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 1 match
MVSFORUMS.com Forum Index
Author Message
  Topic: Eliminating Duplicates - DB2 Query
abalan76

Replies: 6
Views: 2486

PostForum: 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:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group