选择具有临时表的最大值的所有行

I'd like to select all the rows from a temporary table that have a value equal to the maximum value.I'd like to select all the rows from a temporar