Mar 3, 2023 · 8 min read · Learning SQL is like taking a road trip in an unknown desert. Finding a cool oasis with a shade will describe the moments when you are finally able to write queries with simple SELECT statements. The sandstorms will perfectly describe the moments whe...
Join discussionJan 8, 2023 · 6 min read · Like with many articles, this one found its origin in an application bug. A developer came to me saying that the ORDER BY in his SQL gave incorrect results. After some investigation, this article was the result. ORDER BY is so easy to add at the end ...
Join discussionJan 6, 2023 · 3 min read · We ended the last blog by learning the use of the three operators; now, we will look at a keyword that sets our output in order. Points to remember: When you want to arrange the result in ascending or descending order, we use ORDER-BY. The results ...
Join discussion
Aug 3, 2022 · 4 min read · Sometimes you require to order your data in a particular way, and often the use of typical sort modifiers like ASC and DESC are not enough and I am not kind of surprised that you are here because this is the most common challenge a enterprise applica...
Join discussion