--1
SELECT DISTINCT S.学号, S.姓名
FROM students S
INNER JOIN pay P ON P.学号 = S.学号
INNER JOIN dengji D ON D.学号 = S.学号--2
SELECT *
FROM students S
WHERE 性别 = '女'
AND NOT EXISTS (
SELECT TOP 1 1
FROM students
WHERE 性别 = '男'
AND (数学成绩 + 英语成绩) >= (S.数学成绩 + S.英语成绩)
)
SELECT DISTINCT S.学号, S.姓名
FROM students S
INNER JOIN pay P ON P.学号 = S.学号
INNER JOIN dengji D ON D.学号 = S.学号--2
SELECT *
FROM students S
WHERE 性别 = '女'
AND NOT EXISTS (
SELECT TOP 1 1
FROM students
WHERE 性别 = '男'
AND (数学成绩 + 英语成绩) >= (S.数学成绩 + S.英语成绩)
)
)
我看了帮助后,还是不懂
2 select * from students a WHERE 性别 = '女'
and min(数学成绩 + 英语成绩) as 成绩>(
select max(数学成绩 + 英语成绩) as 成绩 from students
where 性别 = '男' )
2 select * from students where 性别 = '女' and (数学成绩 + 英语成绩) as 成绩
>(select max(数学成绩 + 英语成绩) as 成绩 from students where 性别 = '男')