minus in sql
The SQL MINUS operator is used to return
all rows in the first SELECT statement
that are not returned by the second SELECT statement.
Each SELECT statement will define a dataset.
]The MINUS operator will retrieve all records
from the first dataset and then remove from
the results all records from the second dataset.
4
30
UPDATE Inventory
SET Quantity = Quantity - 1
WHERE InventoryID = 2
Thank you!
30
0
Are there any code examples left?
New code examples in category SQL
-
SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
-
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
-
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
-
SQL 2022-03-27 19:20:41 sql is not null
-
SQL 2022-03-27 19:20:39 sql group by error
-
SQL 2022-03-27 18:35:10 replace null with 0 in sql
-
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
-
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
-
SQL 2022-03-27 16:45:07 kill a pid redshift
-
SQL 2022-03-27 16:00:09 joins in sql server