For concatenation, we can either use concat function or using pipeline .      Select concat(first name,lastname) from emp;