select concat(c.firstname, c.lastname) as fullname from Contact c
或者,如果您想要分隔符:
select concat(c.firstname, ' ', c.lastname) as fullname from Contact c
请参阅文档。

select concat(c.firstname, c.lastname) as fullname from Contact c
或者,如果您想要分隔符:
select concat(c.firstname, ' ', c.lastname) as fullname from Contact c
请参阅文档。