SELECT DISTINCT returns only unique rows. Your query, even though it is highly involved, only returns a single row with a single field when you use the SUM() version.

When you do SELECT DISTINCT pp.EffectivePrice, you're eliminating any rows which happen to have the same EffectivePrice value.

so, given some fake return data of

   $1.00
   $2.00
   $1.00
   $3.00

the DISTINCT will hide the duplicate 1 + 3 = 1 from the actual total.

Answer from Marc B on Stack Overflow
🌐
Astra
astra.md › ru › product › vesy-napolnye-el9205
Весы Напольные EL9205
No votes have been submitted yet · Весы Напольные EL9205
🌐
Amazonaws
glnmedia.s3.amazonaws.com › pdf › products › sample_pages › sample_EL9205.pdf pdf
Amazonaws
glnmedia · 2011_School_eCash_Patch.pdf · 2011-09-02T18:45:33.000Z · "54c1d46d006b3ac6715e99b982524ec2" · 57778 · STANDARD · 2011_Student_Sync_Update.pdf · 2011-09-02T18:45:32.000Z · "1b0b8c19cabe57754e8496991f1590e2" · 56353
🌐
Aop
aop.com › search
Product Search - AOP Homeschooling
2024 AOP Catalog Is Here! Find Your Fit > · LIFEPAC Spanish I Unit 5 Worktext is part of a comprehensive Spanish I elective course created just for homeschoolers. Unlike immersion-based programs, this Alpha Omega curriculum focuses on learning the structure and grammar of the Spanish language ...
🌐
Stack Overflow
stackoverflow.com › questions › 7959318 › mysql-issue-with-distinct-sum
php - MYSQL Issue With DISTINCT SUM - Stack Overflow

SELECT DISTINCT returns only unique rows. Your query, even though it is highly involved, only returns a single row with a single field when you use the SUM() version.

When you do SELECT DISTINCT pp.EffectivePrice, you're eliminating any rows which happen to have the same EffectivePrice value.

so, given some fake return data of

   $1.00
   $2.00
   $1.00
   $3.00

the DISTINCT will hide the duplicate 1 + 3 = 1 from the actual total.

Answer from Marc B on stackoverflow.com
🌐
FlightStats
flightstats.com › v2 › flight-tracker › LY › 9205
LY9205 - LY 9205 Flight Tracker
LY9205 Flight Tracker - Track the real-time flight status of LY 9205 live using the FlightStats Global Flight Tracker. See if your flight has been delayed or cancelled and track the live position on a map.
🌐
FlightAware
flightaware.com › live › flight › AMX9205
AM9205 (AMX9205) AeroMéxico Flight Tracking and History - FlightAware
Flight status, tracking, and historical data for AeroMéxico 9205 (AM9205/AMX9205) including scheduled, estimated, and actual departure and arrival times.
🌐
Plane Finder
planefinder.net › flight › LX9205
LX9205 Live Flight Tracker - Plane Finder
Live flight tracker for LX9205. Trusted flight tracking since 2009. Track live flights worldwide on a map and check real time airport status information. Explore detailed aircraft and flight data and playback historical flights.
🌐
Flightpedia
flightpedia.org › flight-status › ly9205.html
EL AL Israel Airlines LY9205 Flight Status - LY 9205 Flight Status
Get the latest status of International flight EL AL Israel Airlines LY9205 from Madrid Barajas International Airport (MAD) to El Dorado International Airport (BOG).
🌐
Ripmax
ripmax.com › Category_List.aspx
Ripmax - Futaba S9205 Spares
Ripmax is one of the largest wholesalers of radio control models & accessories in the UK.
🌐
Aviability
aviability.com › flight-number › flight-ly9205-el-al
LY9205 El Al Flight - Aviability
El Al flight LY 9205 Madrid - Bogota (MAD-BOG), duration 10h 30m, departure 12:05, Madrid Barajas Terminal 4S, arrival 15:35, El Dorado Terminal 1.
🌐
Ferguson
ferguson.com › product › impact-products-infospec-6-in.-deluxe-toilet-plunger-s9205 › 7575496.html
Impact Products 6 in. Deluxe Toilet Plunger | Ferguson
Shop for 6 in. Deluxe Toilet Plunger from Impact Products At Ferguson. Ferguson is the #1 US plumbing supply company and a top distributor of HVAC parts, waterworks supplies, and MRO products.