('1003' ,'男生姓名' , '2000-05-20' , '男');
('1004' , '张三' , '2000-08-06' , '男');
('1005' , '李四' , '2001-12-01' , '女');
('1006' , '女生姓名' , '2001-12-02' , '女');
删除符合条件的记录:是男生时删除name='男生姓名'的记录,是女生时删除name='女生姓名'的记录,如下SQL正确的是()?
delete from table student_table where name = ( case when sex = '男' then '男生姓名' when sex = '女' then '女生姓名' end) ;
delete from student_table where name = ( case when sex = '男' then '男生姓名' when sex = '女' then '女生姓名' end) ;
delete from student_table where name = ( case when sex = '男' then '男生姓名' when sex = '女' then '女生姓名') ;
delete from student_table where name = ( case sex = '男' then '男生姓名' case sex = '女' then '女生姓名' end) ;