SQL - Expanded Form (cont.) SELECT: attributes or functions retrieved in result (columns of result) FROM: all tables needed to do query WHERE: conditions for selecting rows SQL - Expanded Form (cont.) GROUP BY: attributes for grouping - one row in result for each group value HAVING: cond...
Kovse, J., Mahnke, W. (2003). Introducing Custom Language Extensions to SQL:1999. In: Eder, J., Missikoff, M. (eds) Advanced Information Systems Engineering. CAiSE 2003. Lecture Notes in Computer Science, vol 2681. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45017-3...