sql query help

May 13 2011 3:19 PM

I have a history table for Students in SQL Server 2008.

StudentHistoryId, StudentId, Grade, CreatedAt, ModifiedAt, ModifiedBy, Active

How do I write a tsql query to get the latest modified row for all the active students ?