Question on SQL Grouping
- by Lijo
Hi Team,
I am trying to achieve the following without using sub query.
For a funding, I would like to select the latest Letter created date and the ‘earliest worklist created since letter created’ date for a funding.
FundingId Leter (1, 1/1/2009 )(1, 5/5/2009) (1, 8/8/2009) (2, 3/3/2009)
FundingId WorkList (1, 5/5/2009 ) (1, 9/9/2009) (1,…