MAX

Description

The MAX function returns the maximum value in a set of rows. (RedShift SQL Language Reference MAX function).

Grammar Syntax

MAX ( [ DISTINCT | ALL ] expression )

This function is fully supported by Snowflake.

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE TABLE test_max_function (
    col1 INT
 );

INSERT INTO test_max_function
VALUES ('200'),
       ('20'),
       ('2'),
       ('2');

SELECT MAX(COL1), MAX(DISTINCT COL1), MAX(ALL COL1) FROM test_max_function;

Results

SUM(COL1)	SUM(DISTINCT COL1)	SUM(ALL COL1)
200	200	200

Output Code:

Snowflake

OUT -> Redshift_01.sql

CREATE TABLE test_max_function (
    col1 INT
 )
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "11/20/2024",  "domain": "test" }}';

INSERT INTO test_max_function
VALUES ('200'),
       ('20'),
       ('2'),
       ('2');

SELECT MAX(COL1), MAX(DISTINCT COL1), MAX(ALL COL1) FROM
    test_max_function;

Results

SUM(COL1)	SUM(DISTINCT COL1)	SUM(ALL COL1)
200	200	200

Related EWIs

There are no known issues.