P17 SQL Model Clause: A Gentle Introduction by Alex Nuijten

Date & Time

Mar 13th at 10:30 AM until 11:15 AM


Db Development 


Rating ( votes)

The Model Clause adds spreadsheet-like functionality to the SQL language. Very powerful stuff, yet the syntax can be quite daunting. With the Model Clause, you define a multidimensional array from query results and then apply formulas to this array to calculate new values.
This presentation will give you a gentle introduction in the complex syntax of the Model Clause and will show you some real life examples where the Model Clause was invaluable.