MIN

Description

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

Grammar Syntax

MIN ( [ DISTINCT | ALL ] expression )

This function is fully supported by Snowflake.

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE TABLE test_min_function (
    col1 INT
 );

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

SELECT MIN(COL1), MIN(DISTINCT COL1), MIN(ALL COL1) FROM test_min_function;

Results

SUM(COL1)	SUM(DISTINCT COL1)	SUM(ALL COL1)
2	2	2

Output Code:

Snowflake

OUT -> Redshift_01.sql

CREATE TABLE test_min_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_min_function
VALUES ('200'),
       ('20'),
       ('2'),
       ('2');

SELECT MIN(COL1), MIN(DISTINCT COL1), MIN(ALL COL1) FROM
    test_min_function;

Results

SUM(COL1)	SUM(DISTINCT COL1)	SUM(ALL COL1)
2	2	2

Related EWIs

There are no known issues.