select * from pay_ment where cardid='1213456'显示如下
cardid pay_time pay_num
123456 2004-4-1 9:36:14 50
123456 2004-4-1 9:58:07 200
怎样能删除第二条记录pay_num是200的那个
參考答案:delete from pay_ment where cardid='1213456' and pay_num=200
select * from pay_ment where cardid='1213456'显示如下
cardid pay_time pay_num
123456 2004-4-1 9:36:14 50
123456 2004-4-1 9:58:07 200
怎样能删除第二条记录pay_num是200的那个
參考答案:delete from pay_ment where cardid='1213456' and pay_num=200