Select * From mytable Where product = ?Parm1
  And ChangeDate In
   (Select Max(ChangeDate)
     From mytable
     Where product = ?Parm1)