SELECT select_list FROM source_list The select_list specifies the columns from which the data is to be selected, and the source_list specifies the tables or views that have these columns. A query ...

select empno, ename, sal*12 as "annual sal" from emp; --display ename,sal,comm and in the output display sal as basic sal and comm as bonus select ename,sal as "basic sal",comm bonus from emp ...

Not open for further replies. select id, value1, value2, 1 as type from tab2; select id, value1, value2, 2 as type from tab1 where tab1_value1 = "B" and tab1_value2 <> "C"; select id, value1 ...