Posts Tagged ‘coalesce’
OK so it’s not really nefarious but I couldn’t think of another word beginning with “N”.
You may also be relieved to know that this is the dying parp of the vuvuzela on this blog.
This is really just a bit about coalesce – a little used but extremely useful SQL function.
Let’s get the World Cup example out of the way. Here’s a table containing details of the four semi-finalists from this year’s tournament.
Conveniently enough, they consist of two previous winners, one with a best performance as beaten-finalists, and one with a previous best of 4th. Too good an opportunity to miss…. (more…)