# 子查询放置示例

__*子查询的可用位置*__

+ 比地球质量大的行星
+ 比地球或火星质量大的行星
```
SELECT name FROM universe.planets
WHERE mass ~!@>@!~ (SELECT mass 
               FROM universe.planets
               WHERE name = 'Earth');

SELECT name from universe.planets
WHERE mass ~!@> ANY@!~ (SELECT mass
                  FROM universe.planets
                  WHERE name in ('Earth', 'Mars'));
```
-----------------------------------------------------
```
tidb> SELECT name FROM universe.planets
    -> WHERE mass > (SELECT mass 
    ->                FROM universe.planets
    ->                WHERE name = 'Earth');
+--------------------+
| name               |
+--------------------+
| Jupiter            |
| Saturn             |
| Uranus             |
| Neptune            |
| Proxima Centauri b |
+--------------------+
5 rows in set (0.00 sec)

tidb> SELECT name from universe.planets
    -> WHERE mass > ANY (SELECT mass
    ->                   FROM universe.planets
    ->                   WHERE name in ('Earth', 'Mars'));
+--------------------+
| name               |
+--------------------+
| Venus              |
| Earth              |
| Jupiter            |
| Saturn             |
| Uranus             |
| Neptune            |
| Proxima Centauri b |
+--------------------+
7 rows in set (0.00 sec)

```