by Craig S. Mullins | Aug 16, 2021 | CTE, sql
Sometimes what seems like a simple request might take a little bit of thinking to devise and implement a solution. Recently, I was asked how to write SQL that returns the nth maximum value from a column. If you think about it, it isn't too difficult.Assume that you...
by Craig S. Mullins | Nov 18, 2020 | DELETE, sql
I regularly receive database- and Db2-related questions via e-mail. And that is great, but I don't always get a chance to respond to everything. If you've sent me a question and I haven't replied, I apologize. But every now and then, I will use one of the e-mail...
by Modern SQL | Oct 16, 2020 | sql
Markus recently published a video in which he talks about Java & SQL, and that lead to a little discussion with me on Twitter. The conclusion Markus often came to is that one has to revert to writing plain SQL for some of the more advanced use cases because of...
by Craig S. Mullins | Oct 7, 2020 | conference, DBA, idug, sql
For those of you who have attended an IDUG conference before you know why I am always excited when IDUG-time rolls around again. And the EMEA event is right around the corner!Participating at an IDUG conference always delivers a boatload of useful information on how...
by Henrik Loeser (data_henrik) | Jun 17, 2020 | cloud, dashdb, DB2, developer, ibmcloud, jdbc, sql
It seems to me that during the COVID-19 pandemic there are more hackathons than usual. Great to see that IBM Cloud is the platform of choice for many solutions. Db2 on Cloud is used as database, often the free Lite plan to get started. That's the reason I published a...
by Henrik Loeser (data_henrik) | May 18, 2020 | analytics, big data, cloud, data in action, database, DB2, IBM, IT, Life, sql
Learn to write SQLAll of us are impacted by COVID-19. Looking at daily case numbers, the basic reproduction number or mortality rates has become a routine. But what is behind those numbers? How are they computed and how does SQL help? In this post, I want to discuss...
Recent Comments