SQL > SQL????? > Distinct

SELECT ?????? ???? ?? ?? ??? ??? ?? ???? ??? ?? ???. ?? ??? ????? ???? ?? ???? ???? ????.??? ?? ??? ???? ??? ?????? ?????? ??? ????. ????? ??/???? ?? ??? ??? ??? ??? ?? ?? ??? ???? ?????? ??? ?????? SQL???? ?? ?? ?? ????. SELECT ?? DISTINCT ? ???? ???. DISTINCT ? ??? ??? ????:

SELECT DISTINCT "???"
FROM "???";

?? ??,?? ??? Store_Information, ?? ??? ?? ??? ????,

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

??? ?????,

SELECT DISTINCT Store_Name FROM Store_Information;

??:

Store_Name
Los Angeles
San Diego
Boston

SQL WHERE >>
?


Copyright © 2021   1keydata.com   All Rights Reserved