Celko's SQL Stumper: The Class Scheduling Problem

What can we use in SQL instead of E. F. Codd’s T theta operators for best-fit? Joe Celko returns with another puzzle that isn’t new, in fact it already features â??Swedishâ?, â??Croatianâ? and â??Colombianâ? solutions in chapter 17 of Joe’s ‚SQL for Smarties‘ book. These were all written before CTEs or the new WINDOW functions. Is there now a better solution? Was there one even then? We leave it to the readers to provide the answer!

Weiterlesen…