如何将SQL转换为实体查询.

问题描述

我的SQl在下面，请帮助我在实体查询中对其进行转换-

My SQl is below please help me to convert it in Entity Query-

select SUM(total)
from MyTax mt1
inner join (
select Code,ID,TaxYear,Data,max(date) as FinalDate
from MyTax
group by Code,ID,TaxYear,Data) mt2
on mt1.Code = mt2.Code and mt1.ID = mt2.ID
and mt1.Data = mt2.Data and mt1.TaxYear = mt2.TaxYear
and mt1.date = mt2.date

谢谢

Thanks

推荐答案

这篇关于如何将SQL转换为实体查询.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！