SQL > SQL????? > Minus

MINUS ?????? ??? SQL??? ?????. ?? ??? SQL??? ??? ??? ?????.??? ?? ??? ??? SQL??? ???? ??? ?????. ???? ? ???? ???? ??? ??? ???? ????. ?? ??? SQL??? ??? ??? ??? SQL??? ??? ???? ???? ? ???? ?????.

MINUS ? ??:

[SQL ?? 1]
MINUS
[SQL ?? 2];

??? ?? ?? ?? ?????:

Store_Information ??
Store_NameSalesTxn_Date
Los Angeles150005-Jan-1999
San Diego25007-Jan-1999
Los Angeles30008-Jan-1999
Boston70008-Jan-1999

Internet_Sales ??
Txn_DateSales
07-Jan-1999250
10-Jan-1999535
11-Jan-1999320
12-Jan-1999750

??? ???? ?? ???? ?? ??? ???? ??? ??? ???. ? ??? ???? ??? ??? ?? SQL??? ?????:

SELECT Txn_Date FROM Store_Information
MINUS
SELECT Txn_Date FROM Internet_Sales;

??:

Txn_Date
05-Jan-1999
08-Jan-1999

"Jan-05-1999", "Jan-07-1999", und "Jan-08-1999" ? "SELECT Txn_Date FROM Store_Information" ?? ??? ?????.??? "Jan-07-1999" ? "SELECT Txn_Date FROM Internet_Sales," ? ??? ???? ?????. ??? "Jan-07-1999" ? ??? ??? ????.

MINUS ???????? ??? ??? ???? ???? ??? ??????.

SQL Concatenate >>
?


Copyright © 2021   1keydata.com   All Rights Reserved