SELECT * FROM tb_Member_Day_Bonus A
WHERE id in
(SELECT TOP 1 id FROM tb_Member_Day_Bonus
WHERE A.Member_Code = Member_Code ORDER BY hd desc, startdate DESC
)
SELECT * FROM tb_Member_Day_Bonus A
WHERE id in
(SELECT TOP 1 id FROM tb_Member_Day_Bonus
WHERE A.Member_Code = Member_Code ORDER BY hd desc, startdate DESC
)