Sql

-- returns new column named offer_price which is 
-- 20 subtracted to the amount field
SELECT item, amount, amount-20 AS offer_price
FROM Orders;

PREVIOUS	NEXT

Code Example
Sql :: sql alchemy or
Sql :: oracle default date format
Sql :: add column in table
Sql :: how to declare a variable in sql
Sql :: not regexp_like in oracle
Sql :: sqlite insert if not exists
Sql :: How to import CSV file into a MySQL table
Sql :: sql add column with default value
Sql :: stuff sql server
Sql :: oracle group
Sql :: mysql if statement
Sql :: pl sql case
Sql :: sql example query
Sql :: How to find string in substring in sql server
Sql :: postgresql database url
Sql :: postgresql newline character
Sql :: increment id in mysql
Sql :: mysql composite primary key
Sql :: sql statement to change a field value
Sql :: execut sql python
Sql :: oracle tablespace usage
Sql :: sql pivot without aggregate
Sql :: Sequelize model datatype of enum
Sql :: BigQuery Remove Duplicate Keys From Table
Sql :: select other columns with distinct
Sql :: what is cursor in sql server with example
Sql :: sql get month
Sql :: how to check default value of column in sql server
Sql :: GUI for sqlite mac
Sql :: sql server inner join convert collation