0
how to give alias to multiple columns in select statement
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
2 Respuestas
+ 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
- 1
You would like to try
select c1,c1 from table name
where column 1=c1 and column 2=c2.