blob: 5902d21f0a5cf0dd9c9b6e40bbb37df48eb202af [file] [log] [blame]
CREATE OR REPLACE VIEW vwOnParq_11 (col_int, col_bigint, col_char_2, col_vchar_52, col_tmstmp, col_dt, col_booln, col_dbl, col_tm) AS SELECT col_int, col_bigint, col_char_2, col_vchar_52, col_tmstmp, col_dt, col_booln, col_dbl, col_tm from `forViewCrn.parquet`;
SELECT MAX(col_dbl) OVER(PARTITION BY col_char_2 ORDER BY col_int) max_dbl FROM vwOnParq_11;
DROP VIEW vwOnParq_11;