postgresHow to use aliases
SELECT make, model, price AS original_price, ROUND(price*1.13) AS taxed_price FROM car;ctrl + cprice AS original_pricerename column | ROUND(price*1.13) AS taxed_pricemultipy then round each value in the result set, then name this column in the resulting table as |
More of Postgres
- How to filter column based on multiple values
- How to select column which value is between two values
- How to select unique (distinct) values from column
- Order By
- Where
- Select columns from table
- Drop table
- How to group resulting set by specific column values
- Insert into a table
- How to filter resulting set after grouping is done
See more codes...