Habr10h ago

NOT IN — не противоположность IN: что в запросе ломает один NULL

В SQL самые опасные ошибки часто выглядят как рабочие запросы. Они не падают, не ругаются на синтаксис и не подсвечиваются в IDE — просто возвращают пустоту там, где должны быть данные. В этой статье разберём классическую ловушку NOT IN : почему один NULL в подзапросе может «отравить» всю выборку, чем IN на самом деле отличается от NOT IN и почему в таких случаях безопаснее писать через NOT EXISTS .

https://habr.com/ru/companies/otus/articles/1036198/

#SQL #NOT_IN #NULL #NOT_EXISTS #подзапросы #трёхзначная_логика #UNKNOWN #WHERE #антиджойн #ошибки_SQL

NOT IN — не противоположность IN: что в запросе ломает один NULL

Привет, Хабр! В SQL есть отдельный класс ошибок, неприятных именно тем, что они никак себя не проявляют: база не выдаёт исключения, не пишет предупреждения — запрос...

Хабр
Messy Tessy DDs 💕1d ago

Aim here x

#amateurporn #nude #horny #slut #tits #milf #nsfw #where #webslut #goon #gooning

PUB-XMay 7
https://www.pub-x.com/825347/ またjiminがいない。。。 #bts #shorts ##taehyung ##V #arirang #bts #jhope #jimin #jin #jungkook #KPopBoys #KPopIdols #MEXICO #rm #suga #swim #Where #ジミン（JIMIN） #防弾少年団
3i/AtlasMay 1
Drone radar could help spacecraft pinpoint where to drill for water on Mars, scientists say
https://atlas.whatip.xyz/post.php?slug=drone-radar-could-help-spacecraft-pinpoint-where-to-drill-for-water-on-mars-scientists-say
<p>Drone-mounted radar flown over glaciers on Earth show how the technology can map buried ice in detail
#spacecraft #drone #radar #where
Drone radar could help spacecraft pinpoint where to drill for water on Mars, scientists say

Drone-mounted radar flown over glaciers on Earth show how the technology can map buried ice in detail, helping future Mars spacecraft choose exactly where to drill.

Things David LikesApr 30

Where courage meets adversity || Chittagong. by I Am An Amateur Lifestyle Photographer

https://tmblr.co/Z7VXvxjGd8WzCa00

#bangladesh #boat #business #chittagong #coastal #color #economy #fish #fisherman #fishery #fishing #ghat #image #landscape #market #people #photography #seafood #sea #street #traditional #travel #where #courage #meets #adversity #rough #weather #busy #preparations

3i/AtlasApr 29
Your Brain Thinks It Knows Where It Is…. Even When It Doesn’t
https://atlas.whatip.xyz/post.php?slug=your-brain-thinks-it-knows-where-it-is-even-when-it-doesnt
<p>Astronauts take time to adjust how firmly they grip and handle objects when moving between Earth and space
#thinks #brain #knows #where
Your Brain Thinks It Knows Where It Is…. Even When It Doesn’t

Astronauts take time to adjust how firmly they grip and handle objects when moving between Earth and space, because the brain continues making predictions based on whichever gravitational environment ...

3i/AtlasApr 29
One giant leap for AI: Companies rethink how and where data is processed
https://atlas.whatip.xyz/post.php?slug=one-giant-leap-for-ai-companies-rethink-how-and-where-data-is-processed
<p>Big tech and startups are developing orbital data centers to process AI-driven data in space
#companies #rethink #giant #where
One giant leap for AI: Companies rethink how and where data is processed

Big tech and startups are developing orbital data centers to process AI-driven data in space, reducing latency and energy use. This edge computing approach allows satellites to prioritize and transmit...

Smoky_feelApr 28
W?
#why #when #where
#dontforget #monochromaticphotography

#Seduction #heels #highheels #monocromatico #portrait #portraitart #pointofview #portraitphotography #portraitart #beautywomen #eros #sexy #legs #monochromatic #bnwphotography #monochromeart #monochromaticart
MauroGataApr 23

Where

#illustration #digital #digitalillustration #where

3i/AtlasApr 23
Two Worlds Where the Sun Never Moves
https://atlas.whatip.xyz/post.php?slug=two-worlds-where-the-sun-never-moves
Key insight: <p>One side is scorched to over 200 degrees
#worlds #where #never #moves
Two Worlds Where the Sun Never Moves

One side is scorched to over 200 degrees, while the other is plunged into a darkness so cold it falls below minus 200. Welcome to TRAPPIST-1b and 1c, two rocky worlds that have just revealed the first...