How can I rename a single column in a table at select

Question

I have two tables with one identical column name  but different data  I want to join the tables  but access both columns  row  price    row  other price     How can I rename alias one of them in the select statement   I do not want to rename them in the DB

User · Answer

If  like me  you are doing this for a column which then goes through COALESCE   array to json   ARRAY AGG   row to json  PostgreSQL  and want to keep the capitals in the column name  double quote the column name  like so   SELECT a price AS  myFirstPrice   b price AS  mySecondPrice    Without the quotes  and when using those functions   my column names in camelCase would lose the capital letters

User · Answer

Also you may omit the AS keyword    SELECT row1 Price  row2  Other Price  FROM exampleDB table1  in this option readability is a bit degraded but you have desired result

User · Answer

Another option you can choose   select price   table1 price   other price   table2 price from         Reference   In case you are curious about the performance or otherwise of aliasing a column using         versus    as

User · Answer

select t1 Column as Price  t2 Column as Other Price from table1 as t1 INNER JOIN table2 as t2  ON t1 Key   t2 Key    like this

User · Answer

There is no need to use AS  just use   SELECT table1 price Table1 Price  table2 price Table2 Price

User · Answer

us the AS keyword  select a Price as PriceOne  b price as PriceTwo  from tablea a  tableb b

User · Answer

if you are using sql server  use brackets or single quotes around alias name in a query you have in code

User · Answer

select table1 price  table2 price as other price

[sql] How can I rename a single column in a table at select?

Examples related to sql