select distinct xnum from teacher where salary>=all(select salary from teacher where xnum="02")与如上语句等价的sql语句是
时间: 2024-03-22 17:41:15 浏览: 47
select form where 语句
以下是与给定语句等价的 SQL 语句:
```
SELECT DISTINCT t1.xnum
FROM teacher t1
WHERE t1.salary >= (
SELECT MAX(t2.salary)
FROM teacher t2
WHERE t2.xnum = "02"
);
```
阅读全文