Hello everyone,
I have a problem with the following SQL code...
I must transform it into the expression language, and I don't know how this can be done...
Please help me with this.
select count(distinct a.claimid)
FROM Dauna a INNER JOIN
(select ClaimId, Max(ReportingDate) ReportingDate
FROM Dauna
WHERE ReportingDate<= '20111231' GROUP BY ClaimId) b ON a.ClaimId = b.ClaimId AND a.ReportingDate= b.ReportingDate
WHERE a.RezervaRamasa != 0