The SQL WHERE ANY and ALL syntax
The general ANY syntax is:
- SELECT column–names
- FROM table–name
- WHERE column–name operator ANY
- (SELECT column–name
- FROM table–name
- WHERE condition)
The general ALL syntax is:
- SELECT column–names
- FROM table–name
- WHERE column–name operator ALL
- (SELECT column–name
- FROM table–name
- WHERE condition)
SQL ANY Example
Problem: Which products were sold by the unit (i.e. quantity = 1)
- SELECT ProductName
- FROM Product
- WHERE Id = ANY
- (SELECT ProductId
- FROM OrderItem
- WHERE Quantity = 1)
Results: 17 records
ProductName |
---|
Chef Anton’s Cajun Seasoning |
Grandma’s Boysenberry Spread |
Uncle Bob’s Organic Dried Pears |
Ikura |
Konbu |
Tofu |
Teatime Chocolate Biscuits |
Sir Rodney’s Marmalade |
![]() |
SQL ALL Example
Problem: List customers who placed orders that are
larger than the average of each customer order
- SELECT DISTINCT FirstName + ‘ ‘ + LastName as CustomerName
- FROM Customer, [Order]
- WHERE Customer.Id = [Order].CustomerId
- AND TotalAmount > ALL
- (SELECT AVG(TotalAmount)
- FROM [Order]
- GROUP BY CustomerId)
Results: 22 records
CustomerName |
---|
Art Braunschweiger |
Christina Berglund |
Elizabeth Lincoln |
Frédérique Citeaux |
Georg Pipps |
Horst Kloss |
Howard Snyder |
Sebastian Kollmeyer
where to buy genuine viagra online
cbd for pain
french doors with security screens
aluminium security doors
John Deere Technical Manuals
why aren't cbd gummies for sale on amazon
John Deere Diagnostic and Test Manuals
at bing
cbd oil for dogs in seattle
cbd dog seizures
can dogs be allergic to cbd?
cbd infused products canine benefits
pure bud cbd capsules
Resources
this contact form
James Adelblue
Maryanna Lusane
their website
i thought about this
try these out
Continued
check this link right here now
안전해외사이트
Google
안전카지노
look at this now
i thought about this
how to dogs act after cbd
cbd oil for back pain
win money competitions 2020
Willena Beaudion
Jesusita Dowda
does cbd oil work
lawn aerator
Hosea Vaiko
canada pharmacy online
moved here
Basketball hoop installers
over at this website
alberta car towing
roadside assistance
basics
digital marketing salary
White glove furniture delivery
Pool table movers
porno
VitalFlow Sam Morgan
webpage
plumber read what he said
slots bonus
foundation repair san antonio tx
24 hour plumber near me visit homepage
safe playground
출장마사지
HH HILAND Hybrid Bikes for sale
Airwolf for sale
France Denoia
Edison Namauu
안전놀이터
Final mile delivery
Delta 8 THC gummies
Pretty Gaming
Marinda Aramboles
Dunkin Donuts
eye shadows
Aptitude Assessments
Darrel Logarbo
backpack
Spencer Kanable
free horror
University Furnishings Relaxed Collection
Video Mike
Kush Feminized Cannabis Seed Mixpack
Sadye Evins
Does Skincell Pro work to achieve a good vision?
Continue Reading best news viral
제주출장안마
mamashop.com.au
viagra over the counter
Myrtice Hamstra
plus bras
types of vibrators
Ali Mehtani
ProstaStream – Groundbreaking Report on ProstaStream Side Effects vs Benefits
출장마사지
Pumpkin Spice Sean
Top freelancer jobs
online
notice
Torrie Mcdonnall
water delivery dubai
JBO
Playset installation
출장 안마
Fight the social media matrix with capmocracy.com
Aleshia Mondoux
How does Synapse XT work?
game news
plumbing services near me i was reading this
Learn More
free sounds
best app for cheap flights
Cletus Laws
online-casino20.
Best online sale
click now suburbanews.com
Dorris Tisue
click this electric service
cialis for sale
battery drills
Fashion
have a peek here TgnTimes.com
Darrin Epperheimer
Model Tanks
fashion stylist
Discover More Here Lindoron.com
find more bravenewspaper.com
1nza.com
Continue Reading backstretchnews.com
Credit boost
Bio Melt Pro USA
visit the site AbnewsBD.com
Bonuses Aanewshop.com
their explanation legalorium.com
Bradley Howey
online-casino20.
look at here now Arajilinenews.com
water company dubai
download lagu
Charmain Villarin
this website phtimesng.com
netsportworld
official source icetimesmagazine.com
towing vancouver
read this Brawlernews.com
read more
i thought about this Aajnewsok.com
check this Aazadhindnews.com
YOURURL.com ArvoNews.com
this Aoqinews.com
visit their website BestNewsUp.com
Phillip Novy
look these up Attockcitynews.com
my website 0751sgnews.com
over at this website American Valve News
Click here
try this website Acblivenews.com
click site brainwavelive.com
original site AcademyWebNews.com
read the article Bergamowebnews.com
Read More Here australnews.com
you could look here Burkinatimes.com
published here all new sharings
my review here
navigate to these guys A7news.com
great post to read electric repair
have a peek here legal-news-central.com
Can't Pee Ry
this article CallCentreNews.com
see this adn news 24
dig this RadScienceTimes.com
see it here angolapostnews.com
site web Athanews.com
a fantastic read Pro-tec-insider.com
see here now bitarkanews.com
discover this 891news.com
notice
continue reading this 0913News.com
see here now FreeTownDailyNews.com
find us
baltimore mirror installation
click here now bizmarketnews.com
check this BigMarketNews.com
look at this website 7livenews.com
you can try these out breachingnews.com
redirected here Ambrosymedia.com
read what he said bombernews.com
check out this site allnewsnepal.com
original site B2D News
see here now Backwards News Report
More Bonuses Bitarkanews.com
have a peek at this web-site fasotimes.com
Website ADnNews24.com
read review 4news4you.com
Jobs offered
butcher box reviews price
Skincell Pro official website
splendid spoon recycle
this page Blog1News.com
official statement aionews9.com
visit this page BMsportnews.com
visit my profile
internet Boudnews.com
visit my profile
navigate to these guys AisaDailyNews.com
click here to investigate ajdnews.com
YouTube Sean
Get More Information tax preparation frisco texas
i was reading this BioAmericanews.com
find here Botapracorrernews.com
visit my profile
his explanation amarishwardinews24.com
power of video conference
see this here Aisa Daily News
more tips here All Go News
content Allgonews.com
hire someone to clean out house
online transcription service
discover this info here BomberNews.com
imp source blog1news.com
Reversirol reviews
YouTube Ry
purple carrot pre made meals
useful source BM Sport News
review AngolaPostNews.com
view amelia village news paper
Office furniture removal
hop over to this web-site Botapracorrer News
대전출장안마
where does purple carrot ship from
More Bonuses Lindoron.com
special info Boud News
service appliance
see this
check over here bmsportnews.com
click to investigate BreachingNews.com
Office movers
page 0913News.com
Fransisca Shippee
online shopping
coffees.gr
latest hot stories
918kiss
FB88 moi nhat
san andreas indir}
구미출장마사지
대전 출장
GPS Tracker
Popeyes Tay
How to start a blog
bright cellars track my package
roof seam tape home depot
how to start your own banking business
Read Full Article 247realnews.com
Barney Colbeth
일산명월관
link alternatif qq
esamoda
Bubba Kush Feminized Cannabis Seeds
대전출장마사지
glass polish scratches
microsoft office pro plus 2019 product key
Xiao Fontus
Mirror installers
Virginia mirror installation
phim sex online
infant closet organizer
end of lease cleaning Melbourne
garlic pills without soy
aarp approved canadian online pharmacies
Ellis Hodkinson
Pest Removal Orlando
jav sites
agen idn poker
Eliza Bodenhamer
Satchel Crossbody Handbag luv BETSEY Johnson BETSEY Johnson ANNE KLEIN
Creation society maroc
trusted bitcoin investment sites 2020 minimum bitcoin investment,
Abel Urlanza
Torrie Lemery
porn aggregators
labelle pool service
canada online pharmacies trust
pop slots free coins
Mike Uber
best canadian mail order pharmacies
herbi xeberler
Lowell Hoa
schlüsseldienst mangjolli
software developer
123movies
Chilta
fuck ass
Apartment movers
Virginia braiding salon
Wayne Yorty
learn about video projectors ipad
how video projectors work
Lily Jordan
video projectors amazon
Check out
https://porn55.net/
DC Hookah bar
DC black car
Family Health Insurance
managed services hospitality industry addison tx - cloudskope
how can i get free books?
top video projectors under $2,000 2017
funny video
video projectors with high throw ratios
K8vn
this website 4news 4you
how do i get viagra without seeing a doctor
what does tropical fish mean?
get redirected here
what are the 4 main paths of yoga?
El Paso Uber
are kindle books free with amazon prime?
buy youtube views
buy instagram likes
Buy Instagram Followers
VN88
W88yes
Mahi Mike
Supplemental Insurance
upper body muscle building exercises
viagra without doctor prescription usa
heating and air sadler tx
bandar bola terbesar
magnus roth norebo
buy instagram views
ve
∏fi¿Ã¿˙ªÁ¿Ã∆Æ
Patent Attorney San Antonio
Copyright Lawyer
goodman rooftop unit
cbd natural oil
안전놀이터
going here
published here
fuck google
โกงชักดาบ
출장안마
sisteme de copiat
안전놀이터
video game plumber
Robbin Bregon
DC events
꽁머니
situs poker online resmi
what insurance companies cover cialis
best medicine for ed without side effects
百家樂
plumber supply store
Sean Affiliate
Supplemental Insurance
plumbing services Gawler
cialis by paypal
affordable plumbing Gawler
구찌출장
click here now affordable plumbing brisbane
why not try these out plumbing services guildford
where can you buy cialis online
mobile phones
Fang Wallet
bola88 terbaru
Affiliate Ry
does prednisone rase your heart rate
Bernie Anzures
구찌출장
mp3 download
메이저사이트
slot online monsterbola
tadalafil generic or revo
Los Angeles Patent Attorney
buymeacoffee.com/library
Loren Bertovich
עדי שלג
social media
iphone xr specs
Florencio Block
Check This Out royalty free glitch sound effects
Shop Health Insurance
baby travel systems
Hailey Petrosky
용인출장
https://www.free-ebooks.net/profile/1107518/lorentsen-schulz
postmates free delivery march 2021
용인출장
IDGod
Business Opportunity
comprar viagra profesional
เว็บพนันออนไลน์ 88
Barcelona
will viagra help climax
nootropics gnc
look at this site body building ebooks
plumbing contractors straight from the source
look at this site 24 Hour plumber manly
click here now commercial
shed assembly service
คาสิโน
Immigration Lawyer Miami
best place to buy viagra online 2015
Free Health Coverage
Immigration Lawyer In My Area
Lindsey Cilva
rye texas - drivers ed
สล็อต1234joker
Profile Links
Online Casinos
tuzla escort
kanal sanierung
badezimmer renovieren
medication sildenafil
nootropics depot reddit
pendik eskort
check it out emergency plumbers kellyville
look at this site emergency plumbers Melton
grand mondial
divi data
ea forex diamond
Residenial House Cleaner
ProstaStream benefits
우리카지노
klimaanlage ratingen
photovoltaik preise
where can i get sildenafil 100mg
Isatu Tejan-Sie
click site emergency plumber melton
xsmb
Lupe Golden
Profile
sildenafil citrate in natural foods
Divorce Lawyer Montgomery AL
Profile
Carlena Romine
Supplemental Insurance
his comment is here plumber brisbane
walmart miroir video projectors
canvas prints
California Patent Lawyer
Nigeria Property
nootropics vendors reddit
find this golf ebooks
buy bitcoin
emergency plumber near me read this article
Fake New Zealand Driver Licence
sildenafil safeway
Lyft Accident Attorney
canvas prints canada
generate RSS feeds
best natural nootropics
Brendan Procter
OFFICE MOVERS
nootropics vs xanax
nootropics for young
Auto Accident Lawyer
BTC Haberleri
Baltimore mirror installers
หนังออนไลน์0374hd
Pingback: mice
หนังออนไลน์ตลก
ดูบอล ออนไลน์
Joaquina Jarrett
Best divorce lawyer
karkinos
Adrian Molinere
출장
Caroline
Belia Beardslee
Arthur Buonomo
제주출장마사지
roulette offline
Get More Info nootropics for anxiety done,
find this nootropics for energy,
Divorce Lawyer
Athena
Pingback: mouse
Divorce Lawyer Near Me
Young Heldt
Ucuz takici satin al
Wilford Helander
Parker
Diamond Review
Mixing
Handheld Massage Gun
제주출장안마
repair collinsville texas
suggest
สล็อตออนไลน์ พุซซี่
Michael Garnica
how does mr beast make money reddit
샌즈카지노
메리트카지노
เกมสล็อตออนไลน์
제주출장마사지
SlotXo
more info about menterprise
Van Engels
Amelia
hosting reviews
Sandy Takala
Steel Bite Pro website
Cosless.com
Teacher
emergency electrician cronulla
제주 출장안마
check this site out
토토사이트
안전토토사이트
8 movierulz plz
Apps For PC
Commercial Dumpster Rental
Cheap Copyright Lawyer
Trademark San Antonio Law Firm
treadmill installation service
Wan Stopa
kortingscode zeb fashion
Anton Yarboro
buy cocaine online
sa gaming vip
beste wordpress thema voor webshop
전주출장안마
click here
pup border collie opvoeden
광주출장안마
Best CBD Lube
horse tipster
Huntsville Divorce Attorney
What is the best CBD Oil
천안출장안마
https://www.bk8thai.club/
Divorce Law Firm Near Me Free Consultation
Click here
https://phunuz.com/
Vernon Ponds
p2p사이트 순위
נערת ליווי תל אביב
Unfallwagen ankauf
kitchen accessories click here
נערת ליווי תל אביב
메리트카지노
เว็บพนัน
visit profile
west vlaanderen webdesign
부천출장마사지
crypto sace
crawl space encapsulation prices
Divorce Attorney
film sitesi
galileofx
treadmill installation
Angst Beratung
메이저사이트
Loose Leaf Tea
blog
Michele Nicolson
Carson Glunz
수원출장마사지
marketing agency
check my site
kumpulan situs judi bola
Macys Insite Login
studio eden
swing for balcony
swing set installation
Moises Schrage
بازسازی ساختمان
employee portal
Lanell Holmgren
Stephen Donath
website url
best forex strategy 2021
used by god clothing
my blog
https://www.ubgclothing.com/
favored by God clothing
Nathanial Lymon
royalty free images without watermark
Satta Bazar
เครดิตฟรี ไม่ต้องฝาก ไม่ต้องแชร์ แค่สมัคร
Ad jewellery
site link
สล็อต ค่ายใหม่ แจกเครดิตฟรี
Omer Blauvelt
Ucuz instagram takipçi satın al
Terrell Trasher
online clothing store
출장마사지
DMCA Ignored Hosting
Perry Mildenstein
cryptocurrency trading cursus
Guerin Green
how many drops in 2400mg cbd oil
you can try this out
Crystal palace cleaning services
leggings
Instagram influencer finder
video editing software in mac
CBD Lubricant
profile link
Pamelia Bagu
CBD Lube
Pingback: 34cr4rxq3crq34rq3r4
Dog Anxiety
judi casino online terpercaya
situs judi bola sbobet
complaints
DC pool table movers
rapid prototyping
easy ways to make money reddit
teapa lucrare-licenta eu creativ trd srl
Nancy Branford
burning pain in elbow
Devon Ask
baby essentials
constructionscope
kortingscodes belgie
www.laweekly.com/best-cbd-gummies/
Takipçi Satın Al
CBD Lube
Bryon Nager
สล็อตเครดิตฟรีใหม่ล่าสุด
profile link
newborn baby checklist
Mary Divento
Isaura Moitoza
CBD Lube Reviews
Deedee Thelen
Click Here