Reply from jayasathya_venkataraman on Apr 10 at 11:31 AM Hi venki, You got to add up max(effseq) to this following sql. this is my logic...see if it is working out for you. select a.effdt,a.emplid from ps_job a where a.effdt=(select max(c.effdt) from ps_job c where c.effdt < (select max(b.effdt) from ps_job b where b.effdt<sysdt)) Also let me know if there is something wrong with my logic sathya
| | | ---------------Original Message--------------- From: venki k Sent: Monday, April 09, 2012 11:35 PM Subject: How to Find the Second Highest Max effdt from Job Table in PeopleSoft? How to find the second highest max effdt from job table in PeopleSoft? Please respond! Thanks, venki | | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment