![]() ![]() Often you will want to query distinct attributes from the underlying table like this: 'SELECT DISTINCT attribute FROM tbl ORDER BY 1' The second parameter can be any query that returns one row per attribute matching the order of the column definition at the end. ORDER BY 1,2' - could also just be "ORDER BY 1" here There is no room for extra columns like in the 2-parameter alternative below.Ĭrosstab(text, text) with 2 input parameters: SELECT * The simple form is also limited to exactly three columns in the provided input query: row_name, category, value.Sometimes, this behavior is desirable, but not for this use case. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |