通过query-SQL Server查找组中的最后一行

I have table in SQL Server. I want to find last row in each group. I tried with the following query, but it does not return exact result. ID column is PK and other columns are set to NOT NULL.I have table in SQL Server. I want to find last