Select * from student where stuid in(select stuid from score where subject= ’ java ’ and marks>(select marks from score where stuname= ’张三’ ))
C.
Select * from student where stuid in(select stuid from score where subject= ’ java ’ and marks>(select marks from score where subject= ’ java ’ and stuid=(select stuid from student where stuname= ’张三’ )))
D.
Select * from student where stuid in(select stuid from score where subject= ’ java ’ and marks>(select marks from score where stuid=(select stuid from student where stuname= ’张三’ )))