how to give alias to multiple columns in select statement

Question

usually what we do is
select col_name1 c1,col_name2 c2 from table_name;

but I want to know if we can give aliases to multiple columns In one go something like,

I know below statement won't work but this is just for giving an idea what I am trying to achieve

select col_name1 ,col_name2 (c1,c2) from table_name

Answer 1

when u want to give alias u will use "as" on that column or tabel. for example
select column1 as 'c1', column2 as 'c2'
from table1

Answer 2

You would like to try
select c1,c1 from table name
where column 1=c1 and column 2=c2.