我想要做的是对我的会话id进行排序,但它似乎不起作用,因为它只返回"1“。第三行应该是2,第5行应该是2,第6行应该是3,依此类推。我尝试枚举会话。fullVisitorId, pagePath, MIN(timestamp) AS visit_time,
RANKOVER(PARTITION BY CONCAT(fullvisitorId, "-", CAST(timestamp AS S
假设我有以下枚举类型:
private enum ranks { ace = "Ace", two = "2", three = "3", four = "4", five = "5", six = "eight = "8", nine = "9", ten = "10", jack = "Jack", queen = "Queen", king = "Kin