select t1.sudents.id,
t1.sudents_name,
t1.sudents_date,
t2.sudent_sex,
t2.sudent_sore
from sudents t1,sudent t2
where t1.sudents_id=t2.sudent_id
and t2.sudent_sore>=90;delete from sudent t1 where t1.sudent_id=(select sudents_id from sudents t2 where t2.sudents_name='王五');
delete from sudents where sudents_name='王五';select t1.sudents.id,
t1.sudents_name,
t1.sudents_date,
t2.sudent_sex,
t2.sudent_sore
from sudents t1,sudent t2
where t1.sudents_id=t2.sudent_id
and t1.sudents_date>=to_date('2012-06-08','yyyy-mm-dd');