Sven Weller

@svenworacle.bsky.social

Database developer for more than 25 years. CEO for design and development at Syntegris Information solutions GmbH. Low Code APEX enthusiast.

#apexconn26 | Heute um Mitternacht endet die Aktionsphase "Mit dem Early Bird zur APEX connect 2026 – vom 18. bis 20. Mai in den Heide Park Soltau" ⏱️ Jetzt noch zugreifen, um bis zu 260 EUR zu sparen 🤩 Der Clou: Mitglieder erhalten weitere 15 % Rabatt auf diesen Aktionspreis ➡️ scomp.ly/YkRAYpa

Bild

Wir machen mit beim Trend: „Create a caricature of me and my job!“ 🤖 Syntegris = IT-Mission 🚀 Oracle APEX, Java, BI, Security, KI wir bringen alles zusammen. IT-Probleme? Wir biegen das für Sie. 😎 Welcher Bereich ist für Sie am spannendsten?

Bild

I'm working on diagrams to visualize how #SQL works Here are examples comparing different options for FETCH FIRST The table at the top is the input Below it are the rows returned for different options for the dots in ORDER BY NUMBER FETCH FIRST ... Which diagram do you prefer? Other comments?

Top-N queries
The table at the top is the input (from)
The operation is ORDER BY NUMBER FETCH FIRST ...
The results below show which rows are fetched for each of the alternatives ... in FETCH FIRST ...Top-N queries
The table at the top is the input (from)
The operation is ORDER BY NUMBER FETCH FIRST ...
The results below show which rows are fetched for each of the alternatives ... in FETCH FIRST ...