实例 SQL 逻辑运算符 NOT

x
 
SELECT * FROM Customers
WHERE City NOT LIKE 's%';
        
                    

输出结果

CustomerIDCustomerNameContactNameContactTitleAddressCityRegionPostalCodeCountryPhoneFax
ALFKIAlfreds FutterkisteMaria AndersSales RepresentativeObere Str. 57Berlin12209Germany030-0074321030-0076545
ANATRAna Trujillo Emparedados y heladosAna TrujilloOwnerAvda. de la Constitución 2222México D.F.05021Mexico(5) 555-4729(5) 555-3745
ANTONAntonio Moreno TaqueríaAntonio MorenoOwnerMataderos 2312México D.F.05023Mexico(5) 555-3932
AROUTAround the HornThomas HardySales Representative120 Hanover Sq.LondonWA1 1DPUK(171) 555-7788(171) 555-6750
BERGSBerglunds snabbk?pChristina BerglundOrder AdministratorBerguvsv?gen 8Lule?S-958 22Sweden0921-12 34 650921-12 34 67
BLAUSBlauer See DelikatessenHanna MoosSales RepresentativeForsterstr. 57Mannheim68306Germany0621-084600621-08924
BOLIDBólido Comidas preparadasMartín SommerOwnerC/ Araquil, 67Madrid28023Spain(91) 555 22 82(91) 555 91 99
BONAPBon app'Laurence LebihanOwner12, rue des BouchersMarseille13008France91.24.45.4091.24.45.41
BOTTMBottom-Dollar MarketsElizabeth LincolnAccounting Manager23 Tsawassen Blvd.TsawassenBCT2F 8M4Canada(604) 555-4729(604) 555-3745
BSBEVB's BeveragesVictoria AshworthSales RepresentativeFauntleroy CircusLondonEC2 5NTUK(171) 555-1212
CACTUCactus Comidas para llevarPatricio SimpsonSales AgentCerrito 333Buenos Aires1010Argentina(1) 135-5555(1) 135-4892
CENTCCentro comercial MoctezumaFrancisco ChangMarketing ManagerSierras de Granada 9993México D.F.05022Mexico(5) 555-3392(5) 555-7293
CHOPSChop-suey ChineseYang WangOwnerHauptstr. 29Bern3012Switzerland0452-076545
CONSHConsolidated HoldingsElizabeth BrownSales RepresentativeBerkeley Gardens 12 BreweryLondonWX1 6LTUK(171) 555-2282(171) 555-9199
DRACDDrachenblut DelikatessenSven OttliebOrder AdministratorWalserweg 21Aachen52066Germany0241-0391230241-059428
DUMONDu monde entierJanine LabruneOwner67, rue des Cinquante OtagesNantes44000France40.67.88.8840.67.89.89
EASTCEastern ConnectionAnn DevonSales Agent35 King GeorgeLondonWX3 6FWUK(171) 555-0297(171) 555-3373
ERNSHErnst HandelRoland MendelSales ManagerKirchgasse 6Graz8010Austria7675-34257675-3426
FISSAFISSA Fabrica Inter. Salchichas S.A.Diego RoelAccounting ManagerC/ Moralzarzal, 86Madrid28034Spain(91) 555 94 44(91) 555 55 93
FOLIGFolies gourmandesMartine RancéAssistant Sales Agent184, chaussée de TournaiLille59000France20.16.10.1620.16.10.17
FOLKOFolk och f? HBMaria LarssonOwner?kergatan 24Br?ckeS-844 67Sweden0695-34 67 21
FRANKFrankenversandPeter FrankenMarketing ManagerBerliner Platz 43München80805Germany089-0877310089-0877451
FRANRFrance restaurationCarine SchmittMarketing Manager54, rue RoyaleNantes44000France40.32.21.2140.32.21.20
FRANSFranchi S.p.A.Paolo AccortiSales RepresentativeVia Monte Bianco 34Torino10100Italy011-4988260011-4988261
FURIBFuria Bacalhau e Frutos do MarLino RodriguezSales ManagerJardim das rosas n. 32Lisboa1675Portugal(1) 354-2534(1) 354-2535
GALEDGalería del gastrónomoEduardo SaavedraMarketing ManagerRambla de Catalu?a, 23Barcelona08022Spain(93) 203 4560(93) 203 4561
GOURLGourmet LanchonetesAndré FonsecaSales AssociateAv. Brasil, 442CampinasSP04876-786Brazil(11) 555-9482
GREALGreat Lakes Food MarketHoward SnyderMarketing Manager2732 Baker Blvd.EugeneOR97403USA(503) 555-7555
GROSRGROSELLA-RestauranteManuel PereiraOwner5a Ave. Los Palos GrandesCaracasDF1081Venezuela(2) 283-2951(2) 283-3397
HANARHanari CarnesMario PontesAccounting ManagerRua do Pa?o, 67Rio de JaneiroRJ05454-876Brazil(21) 555-0091(21) 555-8765
HUNGCHungry Coyote Import StoreYoshi LatimerSales RepresentativeCity Center Plaza 516 Main St.ElginOR97827USA(503) 555-6874(503) 555-2376
HUNGOHungry Owl All-Night GrocersPatricia McKennaSales Associate8 Johnstown RoadCorkCo. CorkIreland2967 5422967 3333
ISLATIsland TradingHelen BennettMarketing ManagerGarden House Crowther WayCowesIsle of WightPO31 7PJUK(198) 555-8888
KOENEK?niglich EssenPhilip CramerSales AssociateMaubelstr. 90Brandenburg14776Germany0555-09876
LACORLa corne d'abondanceDaniel ToniniSales Representative67, avenue de l'EuropeVersailles78000France30.59.84.1030.59.85.11
LAMAILa maison d'AsieAnnette RouletSales Manager1 rue Alsace-LorraineToulouse31000France61.77.61.1061.77.61.11
LAUGBLaughing Bacchus Wine CellarsYoshi TannamuriMarketing Assistant1900 Oak St.VancouverBCV3F 2K1Canada(604) 555-3392(604) 555-7293
LAZYKLazy K Kountry StoreJohn SteelMarketing Manager12 Orchestra TerraceWalla WallaWA99362USA(509) 555-7969(509) 555-6221
LEHMSLehmanns MarktstandRenate MessnerSales RepresentativeMagazinweg 7Frankfurt a.M.60528Germany069-0245984069-0245874
LILASLILA-SupermercadoCarlos GonzálezAccounting ManagerCarrera 52 con Ave. Bolívar #65-98 Llano LargoBarquisimetoLara3508Venezuela(9) 331-6954(9) 331-7256
LINODLINO-DelicatesesFelipe IzquierdoOwnerAve. 5 de Mayo PorlamarI. de MargaritaNueva Esparta4980Venezuela(8) 34-56-12(8) 34-93-93
LONEPLonesome Pine RestaurantFran WilsonSales Manager89 Chiaroscuro Rd.PortlandOR97219USA(503) 555-9573(503) 555-9646
MAGAAMagazzini Alimentari RiunitiGiovanni RovelliMarketing ManagerVia Ludovico il Moro 22Bergamo24100Italy035-640230035-640231
MAISDMaison DeweyCatherine DeweySales AgentRue Joseph-Bens 532BruxellesB-1180Belgium(02) 201 24 67(02) 201 24 68
MEREPMère PaillardeJean FresnièreMarketing Assistant43 rue St. LaurentMontréalQuébecH1J 1C3Canada(514) 555-8054(514) 555-8055
MORGKMorgenstern GesundkostAlexander FeuerMarketing AssistantHeerstr. 22Leipzig04179Germany0342-023176
NORTSNorth/SouthSimon CrowtherSales AssociateSouth House 300 QueensbridgeLondonSW7 1RZUK(171) 555-7733(171) 555-2530
OCEANOcéano Atlántico Ltda.Yvonne MoncadaSales AgentIng. Gustavo Moncada 8585 Piso 20-ABuenos Aires1010Argentina(1) 135-5333(1) 135-5535
OLDWOOld World DelicatessenRene PhillipsSales Representative2743 Bering St.AnchorageAK99508USA(907) 555-7584(907) 555-2880
OTTIKOttilies K?seladenHenriette PfalzheimOwnerMehrheimerstr. 369K?ln50739Germany0221-06443270221-0765721
PARISParis spécialitésMarie BertrandOwner265, boulevard CharonneParis75012France(1) 42.34.22.66(1) 42.34.22.77
PERICPericles Comidas clásicasGuillermo FernándezSales RepresentativeCalle Dr. Jorge Cash 321México D.F.05033Mexico(5) 552-3745(5) 545-3745
PRINIPrincesa Isabel VinhosIsabel de CastroSales RepresentativeEstrada da saúde n. 58Lisboa1756Portugal(1) 356-5634
QUEDEQue DelíciaBernardo BatistaAccounting ManagerRua da Panificadora, 12Rio de JaneiroRJ02389-673Brazil(21) 555-4252(21) 555-4545
QUICKQUICK-StopHorst KlossAccounting ManagerTaucherstra?e 10Cunewalde01307Germany0372-035188
RANCHRancho grandeSergio GutiérrezSales RepresentativeAv. del Libertador 900Buenos Aires1010Argentina(1) 123-5555(1) 123-5556
RATTCRattlesnake Canyon GroceryPaula WilsonAssistant Sales Representative2817 Milton Dr.AlbuquerqueNM87110USA(505) 555-5939(505) 555-3620
REGGCReggiani CaseificiMaurizio MoroniSales AssociateStrada Provinciale 124Reggio Emilia42100Italy0522-5567210522-556722
RICARRicardo AdocicadosJanete LimeiraAssistant Sales AgentAv. Copacabana, 267Rio de JaneiroRJ02389-890Brazil(21) 555-3412
RICSURichter SupermarktMichael HolzSales ManagerGrenzacherweg 237Genève1203Switzerland0897-034214
ROMEYRomero y tomilloAlejandra CaminoAccounting ManagerGran Vía, 1Madrid28001Spain(91) 745 6200(91) 745 6210
SAVEASave-a-lot MarketsJose PavarottiSales Representative187 Suffolk Ln.BoiseID83720USA(208) 555-8097
SEVESSeven Seas ImportsHari KumarSales Manager90 Wadhurst Rd.LondonOX15 4NBUK(171) 555-1717(171) 555-5646
SIMOBSimons bistroJytte PetersenOwnerVinb?ltet 34Kobenhavn1734Denmark31 12 34 5631 13 35 57
SPECDSpécialités du mondeDominique PerrierMarketing Manager25, rue LauristonParis75016France(1) 47.55.60.10(1) 47.55.60.20
SPLIRSplit Rail Beer & AleArt BraunschweigerSales ManagerP.O. Box 555LanderWY82520USA(307) 555-4680(307) 555-6525
SUPRDSuprêmes délicesPascale CartrainAccounting ManagerBoulevard Tirou, 255CharleroiB-6000Belgium(071) 23 67 22 20(071) 23 67 22 21
THEBIThe Big CheeseLiz NixonMarketing Manager89 Jefferson Way Suite 2PortlandOR97201USA(503) 555-3612
THECRThe Cracker BoxLiu WongMarketing Assistant55 Grizzly Peak Rd.ButteMT59801USA(406) 555-5834(406) 555-8083
TOMSPToms Spezialit?tenKarin JosephsMarketing ManagerLuisenstr. 48Münster44087Germany0251-0312590251-035695
TORTUTortuga RestauranteMiguel Angel PaolinoOwnerAvda. Azteca 123México D.F.05033Mexico(5) 555-2933
TRAIHTrail's Head Gourmet ProvisionersHelvetius NagySales Associate722 DaVinci Blvd.KirklandWA98034USA(206) 555-8257(206) 555-2174
VAFFEVaffeljernetPalle IbsenSales ManagerSmagsloget 45?rhus8200Denmark86 21 32 4386 22 33 44
VICTEVictuailles en stockMary SaveleySales Agent2, rue du CommerceLyon69004France78.32.54.8678.32.54.87
VINETVins et alcools ChevalierPaul HenriotAccounting Manager59 rue de l'AbbayeReims51100France26.47.15.1026.47.15.11
WARTHWartian HerkkuPirkko KoskitaloAccounting ManagerTorikatu 38Oulu90110Finland981-443655981-443655
WELLIWellington ImportadoraPaula ParenteSales ManagerRua do Mercado, 12ResendeSP08737-363Brazil(14) 555-8122
WILMKWilman KalaMatti KarttunenOwner/Marketing AssistantKeskuskatu 45Helsinki21240Finland90-224 885890-224 8858
WOLZAWolski ZajazdZbyszek PiestrzeniewiczOwnerul. Filtrowa 68Warszawa01-012Poland(26) 642-7012(26) 642-7012