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

23rd Aug 2016, 11:12 AM
Satish Hambarde
Satish Hambarde - avatar
2 Respostas
+ 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
23rd Aug 2016, 4:01 PM
Mersad Secic
Mersad Secic - avatar
- 1
You would like to try select c1,c1 from table name where column 1=c1 and column 2=c2.
23rd Aug 2016, 3:47 PM
Sky Balwan
Sky Balwan - avatar