SQL > SQL????? > Between

IN ?????? ?? ?? ???? ??? (discrete) ??? ??? ?? ???????? ??? ??? ?? ?? BETWEEN ? ??? ??(range)? ???? ???????? ??? ??? ?? ???. BETWEEN ??? ??? ??? ????:

SELECT "???"
FROM "???"
WHERE "???" BETWEEN '??1' AND '??2';

??? ??1? ??2??? ??? ???? ?? ???? ???? ????.

?? ?? Store_Information ?????January 6, 1999 ? January 10, 1999 ? ???? ?? ??? ?? ??,

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 Txn_Date BETWEEN 'Jan-06-1999' AND 'Jan-10-1999';

???? ?? ??:??? ??????? ?? ???? ????? ????. ??? ??? ??? ?? ??? ???????.

??:

Store_Name Sales Txn_Date
San Diego 250 Jan-07-1999
San Francisco 300 Jan-08-1999
Boston 700 Jan-08-1999

SQL LIKE >>
?


Copyright © 2021   1keydata.com   All Rights Reserved