This content has been marked as final. Show 3 replies
do u want to rename the columns during query execution time or in the table itself???
if in the query execution time then:
select empname as employeename,empno as employeenum from employee;
if you want to rename the columns in the table itself then:
alter table employee rename column empno to employeenum;