Last updated
Last updated
The SELECT list names the columns, functions, and expressions that you want the query to return. The list represents the output of the query. ()
The are fully supported in Snowflake. Just keep in mind that in Snowflake the DISTINCT
and ALL
options must go at the beginning of the query.
In Redshift, if your application allows foreign keys or invalid primary keys, it can cause queries to return incorrect results. For example, a SELECT DISTINCT query could return duplicate rows if the primary key column does not contain all unique values. ()
There are no known issues.
There are no related EWIs.
100
Carlos
null
101
John
100
102
Jorge
101
103
Kwaku
101
110
Liu
101
100
Carlos
null
101
John
100
102
Jorge
101
103
Kwaku
101
110
Liu
101
null
100
101
101
101
102
103
103
103
104
104
102
104
null
100
101
101
101
102
103
103
103
104
104
102
104
null
100
101
102
103
104
null
100
101
102
103
104