Help With Sql Query Returning Last Max Record

I am having problems with a SQL query.

Table has 10 fields and I need to return them all. The three most importaint, at least for the filter I need are:

id, studentid, date, canceled.

I need to return the last max(date) grater than or equal to @dateparam which is not canceled for each studentid

I have worked out some solutions but am not happy with them. Specially woried about performance when the table grows. I am expecting in full production a table growth of about 3 million records per month.

what would be grate is if there where a way of returning a the coresponding id like in:

select studentid, max(date), related(id) as ids
from tablea
where canceled=0
group by studentid

then I could do:

Select *
from tablea inner join (select studentid, max(date), related(id) as ids
from tablea a
where canceled=0
group by studentid
) b on (a.id=b.ids)