0
I want to use group by in C#, and my result must be like this code in SQL: SELECT MAX(EffectiveDate) AS EffectiveDate,details.PersonnelBaseID FROM dbo.tkp_PersonnelDetails AS details where details.EffectiveDate <= @Time GROUP BY PersonnelBaseID @Time is an input parameter; assume tkp_Personn...