SQL > SQL????? > In

SQL??? ??? ?????? IN ?????? ????;? ?????? ??? ???: WHERE ? ??? ??? ?? ?????. ? ????? ?? ??? ??? ??? ??? ?? ???? ? ???? IN ?? ???IN ?????? ??? ??? ????:

SELECT ""???"
FROM "???"
WHERE "???" IN ('??1', '??2', ...);

????? ?? ?? ???? ??? ??? ??? ??? ??? ??? ?????. ??? ????? ?? ??? ????. ???? ??? ??? ?????? ???

WHERE "???" = '??1'

?? ?? Store_Information ???? Los Angeles ? San Diego ? ??? ?? ???? ?? ??

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

??? ?????,

SELECT *
FROM Store_Information
WHERE Store_Name IN ('Los Angeles', 'San Diego');

??:

Store_Name Sales Txn_Date
Los Angeles 1500 Jan-05-1999
San Diego 250 Jan-07-1999

SQL BETWEEN >>
?


Copyright © 2021   1keydata.com   All Rights Reserved