Let's say I have a table with two columns first and last name, for example:
Nome | Sobrenome
-------+-----------
João | Silva
Mike | Corin
Carlos | Rodrigues
And I want to join the column of the name with the last name, to get the full name:
Nome
-----------------
João Silva
Mike Corin
Carlos Rodrigues
How can I do this? Without it being manually, perhaps with a function because you already have millions of records and doing this manually will take too long.