Sql Query to combine first name and last name

SQL Query to combine first name and last name

ans:

select (firstname+ ' ' + lastname) as fullname from emp