Amazing! I can have multiple columns in group/order by clause. SAS log always have "NOTE: The query requires remerging summary statistics back with the original data." Good alternative to row_number() over ([partition_by_clause] order_by_clause) say Impala SQL. Thanks! @Ksharp
... View more