How to rename columns with `SELECT`?

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)

Solution

SELECT table1.price, table2.price AS other_price ...

SQL copying data with new foreign keys
An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
space is not allowed after parameter prefix ':' in SpEL support in Spring Data JPA @Query definitions
SQLAlchemy - Get query results in same order as IN clause
SQL Grouping and Nested Concatenation
Extract weekday, millisecond, microsecond, nanosecond from a date in Postgres
How can I refer to a variable in postgresql dynamic SQL?
How to pull width & height out of string?
Add new columns without using Alter
Get columns of index on DB2
Athena Query - "NOT IN" slow performance
SQL one to one relationship vs. single table
How can I number the instance of a duplicate record?
How to fix SQL for AWS Athena
SQL SELECT query not working in mysql
How can i insert/ select into a table and delete copied records from original table?
How to convert oracle regex pattern into Databricks compatible version?
Select min or max based on where duplicate value exists
Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
WHERE clause pulling incorrect values
Sql select all conversation by group
Create an inline SQL table on the fly (for an excluding left join)
How to execute raw SQL in Flask-SQLAlchemy app
Update SQL table using selection from another table
Clarification on joins
Foreign key constraint may cause cycles or multiple cascade paths?
PowerApps retrieving data from SQL using compound criteria
T-SQL Get File Extension Name from a Column
postgres - How to parse json array elements?
How to query the distribution (grouped by value range) of a column value in Oracle?