I want to create a view in AOT that does the same as the following query

I want to create a view in AOT that does the same as the following query:

select t1.ExecutionId , t1.DefinitionGroup , t2.ServiceDescription from DMFDefinitionGroupExecution t1 inner join ServiceParameters t2 on t1.DEFINITIONGROUP = t2.DEFINITIONGROUP where t1.CREATEDDATETIME = ( select max(CREATEDDATETIME) from DMFDefinitionGroupExecution t2 where t1.DEFINITIONGROUP = t2.DEFINITIONGROUP) group by t1.ExecutionId , t1.DefinitionGroup , t2.ServiceDescription


but I have no idea on how to add that range with the max in the designer.

 

Any ideas on that?

Thanks in advance

Saanvi 

Related
Recommended