It will give the empids list from the table, with column 
name as empname.
This implies the general syntax of renaming a column when 
retriving data.
syntax: select dbcolumnname as newcolumnname from table1
OR
select dbcolumnname newcolumnname from table1.
Both the statements means the same.