![]() For our purposes, the final result is defined as:ĪS final_result(Student TEXT, Geography NUMERIC,History NUMERIC,Language NUMERIC,Maths NUMERIC,Music NUMERIC) We must define the names of the columns and data types that will go into the final result. The crosstab function is invoked in the SELECT statement's FROM clause. SELECT student, subject, evaluation_result FROM evaluations ORDER BY 1,2 In our example, the SELECT parameter will be: If we think of our pivot table as a two-dimensional array, then the first SELECT column is the first array dimension, the second SELECT column is the second dimension, and the third is the array element value.like grid = third_column_value. ![]() These are the evaluation results in our example.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |