![]() Finding “Facts” or “Pivot” columns work only for table based pivot tables. Finding the “Facts” column, by default the last column of the source table.The CONNECT implementation of the PIVOT table type does much of the work ![]() You can now use it as any other table, for instance to display the result shown With the statement: create table pivex engine = connect table_type = pivot tabname = expenses To get the result shown in the example above, just define it as a new table The Pivot table type of CONNECT makes doing this much simpler. However there is no way to get the pivoted layout shown above just using SQL.Įven using embedded SQL programming for some DBMS is not quite simple and The “group by” clause, namely: select who, week, what, sum ( amount ) from expenses group by who, week, what Note that SQL enables you to get the same result presented differently by using
0 Comments
Leave a Reply. |