can we an alias column along with the asterisk(*)
441533Apr 5 2005 — edited Apr 7 2005Hello Everybody,
Can we use an alias name along with the *.
Eg: if we want to select annual salary along with all the columns in the emp table.
SELECT *,SAL*12 ANN_SAL FROM EMP WHERE SAL*12>30000;
This query is running as an error.what is the alternate way to do the same thing with out writing all the column names in the select statement