| Reply from Abydude on Apr 10 at 11:47 AM                                       | Use this as an example select max(effdt) from ps_job  where effdt<>(select max(b.effdt) from ps_job b where b.emplid='00212364') and emplid='00212364';
 
 
 |  |  |  | ---------------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