Pity the poor developer or end user that has never had the chance to use "real" SQL. You know, the kind of SQL that does more than select a few rows with possibly a few predicates thrown in?
April 2015 “Fun with SQL” Challenge 2
This month on the Content Committee blog we’ll be doing an online version of the “Fun with SQL” dojo. Each week we’ll present an SQL challenge and request the community to solve it.
IDUG is dedicated to the support of not only database administrators, but also developers who use our databases. This means that we’re dedicated to sharing information about the many features of SQL and of DB2 in particular. Why is this important? Well, for some very basic reasons.
How many copies of your databases do you have? I’m talking about both how many test databases with test data as well as full copies of your production data. In many shops, developers are well behaved and get along nicely. They share test databases.
Support for the declaration and manipulation of temporal data was added to the SQL standards in the revision of the standard formally adopted in December 2011 (SQL:2011 and ISO/IEC 9075:2011). Since then support has been added in both DB2 for z/OS (10 onwards) and DB2 for LUW (V10.1 onward).