Sql/oracle format

[chetah]

I am using a table called Employees. I want to display:
Smith 7898
John 7856

What should I do to get the above format?

[Parul Bagadia]

select the columns which are having above information, and it will be displayed.

[debasisdas]

what is the sql you have tried.