column alias:

select empno "eid",ename, mgr,hiredate "hire", deptno "dept" from emp

 
Oracle:

PostgreSQL:

 

MYSQL: