将4列的值显示成一列指定名字的表
select ( prefix||' ' ||first||' ' || last||' ' || suffix) as title from names
SELECT concat_ws(' ', prefix,first,last,suffix) AS title FROM names;
将4列的值显示成一列指定名字的表
select ( prefix||' ' ||first||' ' || last||' ' || suffix) as title from names
SELECT concat_ws(' ', prefix,first,last,suffix) AS title FROM names;