求解此方法怎样实现？？？(50分)

JSH HJJE XM
1-删除 ￥111.00 硬黄鹤楼
2 ￥39.00 男宾洗浴
2-删除 ￥118.00 足疗
3 ￥38.00 矿泉水
1 ￥33.00 硬黄鹤楼
2 ￥5.00 硬黄鹤楼
3-删除 ￥150.00 男宾洗浴
2 ￥38.00 矿泉水
1 ￥31.00 男宾洗浴
4-删除 ￥5.00 男宾洗浴
我现在想删除jsh为一组的最大值，
delete from table1 where (select max(HJJE) from table1 group by JSH,这个方法好像不行！
并删作后并求sum(hjje)的和!
请问用什么语句比较合适，我想了有一段时间隔就是没有一个结果？？烦恼中.....

delete from table1 where (select max(HJJE) from (select * from table1 group by JSH))

delete from table1 where hjje in (select max(HJJE) hjje from table1 group by JSH))

Delete Table1
From Table1 Right Join (Select JSH, max(HJJE) HJJE From Table1 Group by JSH) T
On Table1.JSH = T.JSH

To:李翔鹏
你的语句很危险！如果有记录的‘hjje’恰好等于某个‘JSH’的最大值也将被删除！
To：ChrisMao
你的语句应该加个条件：
Delete Table1
From Table1 Right Join (Select JSH, max(HJJE) HJJE From Table1 Group by JSH) T
On Table1.JSH = T.JSH AND Table1.HJJE = T.HJJE