当前位置：网站首页>[SQL] sql32 sets the last of all employees in the employees table_ Name and first_ Name splicing

[SQL] sql32 sets the last of all employees in the employees table_ Name and first_ Name splicing

2022-04-21 21:05:00 【A research monk who doesn't like research】

subject ：

take employees Table for all employees last_name and first_name Spliced together as Name_ Niuke Tiba _ Cattle from

Existing employee table employees as follows ：

emp_no birth_date first_name last_name gender hire_date
10001 1953-09-02 Georgi      Facello    M 1986-06-26
10002 1964-06-02 Bezalel     Simmel     F 1985-11-21
10003 1959-12-03 Parto Bamford M 1986-08-28
10004 1954-05-01 Chirstian Koblick M 1986-12-01
10005 1955-01-21 Kyoichi Maliniak M 1989-09-12
10006 1953-04-20 Anneke Preusig F 1989-06-02
10007 1957-05-23 Tzvetan Zielinski F 1989-02-10
10008 1958-02-19 Saniya Kalloufi M 1994-09-15
10009 1952-04-19 Sumant Peac F 1985-02-18
10010 1963-06-01 Duangkaew Piveteau F 1989-08-24
10011 1953-11-07 Mary Sluis F 1990-01-22

Please put employees Table for all employees last_name and first_name Spliced together as Name, Use a space in the middle to distinguish .

( notes ：sqllite, String concatenation as || Symbol , I won't support it concat function ,mysql Support concat function ).

Input description ：

nothing

Output description ：

Name
Facello Georgi
Simmel Bezalel
Bamford Parto
Koblick Chirstian
Maliniak Kyoichi
Preusig Anneke
Zielinski Tzvetan
Kalloufi Saniya
Peac Sumant
Piveteau Duangkaew
Sluis Mary

Answer key ：

Use concat function , You can splice multiple fields

1.concat function ：

  • effect : Take multiple results as character string Splice together

  • grammar :
    CONCAT(str1,str2...)

2. concat_ws function

  • effect ： Splice multiple results together , Use the specified separator

  • grammar ：
    CONCAT_WS(separator,str1,str2,...)

select
    concat(last_name, ' ', first_name)
from
    employees

版权声明
本文为[A research monk who doesn't like research]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204212059008620.html

边栏推荐

猜你喜欢

随机推荐