题解 | 顾客登录名
顾客登录名
https://www.nowcoder.com/practice/7cbf5e3082954c21a80fc750ce97350f
select
cust_id,
cust_name,
upper(#大写SELECT UPPER('Hello');
concat(#合并 拼写CONCAT('Hello', 'World');
substring(cust_name, 1, 2),#切片（起始索引为1）SELECT SUBSTRING('Hello World', 1, 5);
substring(cust_city, 1, 3)
)
) as user_login
from
Customers;
查看6道真题和解析