SQL拼接的问题 想在查出来的结果中deptname字段的每个结果中都加上用车申请

这是现在的SQL语句 select dept_name,relation_people,starttime,endtime from vehicle_requisition order by starttime desc

如图我想在查出来的结果中deptname字段的每个结果中都加上用车申请 请问怎么拼接sql语句啊

concat函数要比连接符‘||’稳定

SQL: SELECT '用车申请'+dept_name,relation_people,starttime,endtime FROM vehicle_requisition order by starttime desc;
MYSQL: SELECT CONCAT('用车申请',dept_name) as dept_name,relation_people,starttime,endtime FROM vehicle_requisition order by starttime desc;

我用的是mysql：
select concat(dept_name,"用车申请") as "dept_name" ,relation_people,starttime,endtime from vehicle_requisition order by starttim

sqlserver
dept_name + '用车申请’
mysql
CONCAT(dept_name,'用车申请’)

select CONCAT(dept_name,用车申请对应字段),relation_people,starttime,endtime from vehicle_requisition order by starttime desc;

sssssssssssssssssssssssssssssssssssssssssssss
pg：
select dept___name||'用车申请',__relation_people,starttime,endtime from vehicle_requisition order by starttime desc