How to filer max id and return the last row in the Azure Data flow. Or use Filter in data flow and get only last max id.
SELECT Level1Id FROM [D].[DepartmentGroupLevel1]
WHERE [Level1Id] = (SELECT MAX([Level1Id]) FROM [D].[DepartmentGroupLevel1])
How to filer max id and return the last row in the Azure Data flow. Or use Filter in data flow and get only last max id.
SELECT Level1Id FROM [D].[DepartmentGroupLevel1]
WHERE [Level1Id] = (SELECT MAX([Level1Id]) FROM [D].[DepartmentGroupLevel1])
It should just be an Aggregate without any group-by. Group by is optional in the Agg transformation.