MySQL 子查询以大写形式显示
本文关键字:显示 查询 MySQL | 更新日期: 2023-09-27 18:34:28
[完成] 对于那些需要这个的人。我将编辑此内容并将答案放在下面..
如何使用子查询使 LName 和 FName 全部大写?我已经使所有 LName 和 FName 大写,但不使用此代码在子查询中
Select UPPER(LName) AS "Lastname", UPPER(FName) AS "Firstname" FROM Trainers;
输出:
+-----------+-----------+
| Lastname | Firstname |
+-----------+-----------+
| MONTANO | GERALD |
| ALEJANDRO | LEONARD |
| MONTEZ | GARY |
| GUILLERMO | JACKIE |
| SANCHEZ | VERNA |
| GABORNI | MICHELLE |
+-----------+-----------+
餐桌训练器
+-----------+-----------+----------+-------+
| TrainerNo | LName | FName | Rate |
+-----------+-----------+----------+-------+
| 00804871 | Montano | Gerald | 200 |
| 00807461 | Alejandro | Leonard | 175 |
| 00807462 | Montez | Gary | 150 |
| 00823253 | Guillermo | Jackie | 200 |
| 00827320 | Sanchez | Verna | 125 |
| 00845907 | Gaborni | Michelle | 150 |
+-----------+-----------+----------+-------+
答:
Select UPPER(Lname) AS "Lastname", UPPER(FName) AS "Firstname" from Trainers Where Rate <= (Select Max(Rate) from Trainers);
如果要在子查询中返回与大写的第二个名称连接的第一个名称。然后你可以这样做。
Select * from Table Name, (Select UPPER(LName) + UPPER(FName) FROM Trainers) as Name