Is there a way to add an additional column after SELECT *?

Question

I would like to SELECT all the columns from my employees table + a an additional calculated column from the same table without manually typing all the columns.

I have thought about this:

SELECT *, salary *2 FROM employees;

However attempting to do so I get the error:

923. 00000 - "FROM keyword not found where expected"

Answer 1

You would need to alias the table :

SELECT e.*, e.salary *2 FROM employees e; 

Answer 2

You can try this

SELECT employees.*, employees.salary *2 FROM employees;