[OLD] SnowConvert - LIMITED ACCESS
  • SnowConvert Translation Reference
  • Licensing
  • Download and Access
  • For Teradata
    • Translation Reference
      • Scripts to Snowflake SQL Translation Reference
        • COMMON STATEMENTS
          • ERROR HANDLING
          • EXIT or QUIT
          • GOTO
          • IF... THEN...
        • BTEQ
        • MLOAD
          • Import
      • Scripts To Python Translation Reference
        • BTEQ
          • REPEAT
          • USING REQUEST MODIFIER
        • FLOAD
          • BEGIN LOADING
        • MLOAD
          • BEGIN MLOAD
        • TPT
        • SnowConvert Scripts Helpers
          • Technical Documentation
      • SQL Translation Reference
        • Built-in Functions
          • Cast to DATE using { }
          • Cast to INTERVAL datatype
          • COALESCE
          • DAYNUMBER_OF_MONTH
          • FROM_BYTES
          • GETQUERYBANDVALUE
          • JSON_CHECK
          • JSON_EXTRACT
          • JSON_TABLE
          • NEW JSON
          • NVP
          • OVERLAPS
          • PIVOT
          • P_INTERSECT
          • RANK
          • Regex functions
          • STRTOK_SPLIT_TO_TABLE
          • SUBSTRING
          • TD_UNPIVOT
          • TO_CHAR
          • XMLAGG
        • Database DBC
        • Data Types
        • DDL
          • Tables
          • Index
          • Views
        • DML
          • Delete Statement
          • Insert Statement
          • Select Statement
            • Expand On Clause
            • Normalize
            • Reset When
          • Set Operators
          • Update Statement
          • With Modifier
        • SnowConvert Procedures Helpers
          • Cursor Helper
          • Exec Helper
          • Functional Equivalence Helpers
          • Into Helper
      • Teradata to JavaScript Translation Reference
        • GET DIAGNOSTICS EXCEPTION
        • Macros
        • Procedures
      • Teradata to Snowflake Scripting Translation Reference
        • ABORT and ROLLBACK
        • BEGIN END
        • CASE
        • CREATE MACRO
        • CREATE PROCEDURE
        • CURSOR
        • DECLARE
        • DECLARE CONDITION HANDLER
        • DML and DDL Objects
        • EXCEPTION HANDLERS
        • EXECUTE IMMEDIATE
        • EXECUTE/EXEC
        • GET DIAGNOSTICS EXCEPTION
        • IF
        • LOOP
        • OUTPUT PARAMETERS
        • PREPARE
        • REPEAT
        • SET
        • WHILE
        • WITH DEFAULT
  • For Oracle
    • Translation Reference
      • Sample data
      • Basic Elements of Oracle SQL
        • Data Types
          • Oracle Built-in Data Types
            • Character Data Types
              • CHAR Data type
              • NCHAR Data Type
              • VARCHAR2 Data Type
              • VARCHAR Data Type
              • NVARCHAR2 Data Type
            • Numeric Data Types
              • NUMBER Data Type
              • FLOAT Data Type
              • Floating-Point Numbers
                • BINARY_FLOAT
                • BINARY_DOUBLE
            • LONG Data Type
            • Datetime and Interval Data Types
              • DATE Data Type
              • TIMESTAMP Data Type
              • TIMESTAMP WITH TIME ZONE Data Type
              • TIMESTAMP WITH LOCAL TIME ZONE Data Type
              • INTERVAL YEAR TO MONTH Data Type
              • INTERVAL DAY TO SECOND Data Type
              • Datetime Arithmetic
                • Interval UDFs vs Snowflake native interval operation
            • LOB Data Types
              • BFILE Data Type
              • BLOB Data Type
              • CLOB Data Type
              • NCLOB Data type
            • JSON Data Type
            • Extended Data Types
            • RAW and LONG RAW Data types
            • PL SQL Data Types
              • PLS_INTEGER Data Type
              • BINARY_INTEGER Data Type
          • Rowid Data Type
            • ROWID DataType
            • UROWID Data Type
          • ANSI Data Types
          • User-Defined Types
            • REF Data Types
          • Any Types
            • ANYTYPE
            • ANYDATA
            • ANYDATASET
          • XML Types
            • XMLType
            • URI Data Types
              • HTTPURIType
              • XDBURIType
              • DBURIType
            • URIFactory Package
          • Spatial Types
            • SDO_GEOMETRY
            • SDO_TOPO_GEOMETRY
            • SDO_GEORASTER
        • Literals
          • Text literals
      • Pseudocolumns
        • ROWID
        • ROWNUM
      • Built-in functions
        • SnowConvert Custom UDFs
          • BFILENAME UDF
          • DATE TO JULIANDAYS UDF
          • DATEADD UDF
          • DATEDIFF UDF
          • INTERVAL UDFs
            • DATEADD UDF INTERVAL
            • DATEDIFF UDF INTERVAL
          • JSDATE UDF
          • JSON_VALUE UDF
          • JULIAN TO GREGORIAN DATE UDF
          • MONTHS BETWEEN UDF [DEPRECATED]
          • REGEXP LIKE UDF
          • TIMESTAMP DIFF UDF
          • TRUNC (date) UDF
          • TRUNC (number) UDF
      • Built-In packages
        • DBMS_LOB
          • SUBSTR Function
        • DBMS_RANDOM
          • VALUE functions
        • DBMS_OUTPUT
          • PUT_LINE procedure
        • UTL_FILE
          • FOPEN procedure
          • PUT_LINE procedure
          • FCLOSE procedure
      • SQL Queries and Subqueries
        • Select
          • Select Flashback Query
        • Joins
          • Equijoin
          • Band Join
          • Self Join
          • Cartesian Products
          • Inner Join
          • Outer Join
          • Antijoin
          • Semijoin
      • SQL Statements
        • Alter Session
        • Alter Table
        • Create Materialized Views
        • Create Database Link
        • Create Index
        • Create Sequence
        • Create Synonym
        • Create Table
        • Create Type
          • Object Type Definition
          • Subtype Definition
          • Array Type Definition
          • Nested Table Type Definition
          • Member Function Definitions
        • Create View
        • Drop Table
      • PL/SQL to Snowflake Scripting
        • ASSIGNMENT STATEMENT
        • CALL
        • CASE
        • COLLECTIONS AND RECORDS
          • Associative Array Type Definition
          • Varray Type Definition
          • Nested Table Array Type Definition
          • Collection Methods
          • Collection Bulk Operations
            • WITH, SELECT, and BULK COLLECT INTO statements
          • Record Type Definition
        • COMPOUND STATEMENTS
        • CONTINUE
        • CREATE PROCEDURE
        • CURSOR
          • Workaround for cursors using parameters or procedure variables
          • Cursor Variables
        • DECLARE
        • DEFAULT PARAMETERS
        • DML STATEMENTS
          • INSERT Statement Extension
          • MERGE Statement
          • SELECT INTO Statement
          • Work around to simulate the use of Records
        • EXIT
        • EXPRESSIONS
        • EXECUTE IMMEDIATE
        • FORALL
        • FOR LOOP
        • HELPERS
          • Bulk Cursor Helpers
        • IF
        • IS EMPTY
        • LOG ERROR
        • LOOP
        • OUTPUT PARAMETERS
        • PACKAGES
          • DECLARATION
          • BODY
          • VARIABLES
          • Constants
        • PROCEDURE CALL
        • RAISE
        • RAISE_APPICATION_ERROR
        • UDF CALL
        • WHILE
      • PL/SQL to Javascript
        • Procedures
        • User defined functions
        • Packages
        • Helpers
          • EXEC Helper
          • Cursor Helper
          • Raise Helper
          • ROWTYPE Helper
          • Between operator helper
          • Like operator Helper
          • IS NULL Helper
          • Concat Value Helper
          • Package variables helper
          • Implicit Cursor attribute helper
        • Declarations
        • Control Statements
        • Conditional Compilation
        • Collections & Records
        • DDL - DML Statements
        • SQL Language Elements
        • Expressions and operators
        • Synonyms
        • Triggers
        • TYPE attribute
      • SQL*Plus
        • Archive Log
        • Attribute
        • Break
        • Btitle
        • Change
        • Column
        • Define
        • Host
        • Prompt
        • Remark
        • Set
        • Spool
        • Start
        • Whenever oserror
        • Whenever sqlerror
        • Show
        • Append
        • Accept
      • Wrapped objects
  • For SQL Server
    • Translation Reference
      • General Language Elements
        • EXECUTE
        • Collate
        • USE
        • OUTER APPLY
      • DDLs
        • Tables
        • Index
        • Views
        • Procedures
        • Functions
      • DMLs
        • Set Operators
        • Between
        • Update
        • Select
        • Insert
        • Delete
        • Merge
        • Exists
        • IN
        • Truncate
        • Drop
        • Bulk Insert
        • Common Table Expression (CTE)
        • Drops
      • Data Types
      • Statements
        • ALTER
          • TABLE
            • ADD
              • COLUMN DEFINITION
                • COLUMN CONSTRAINT
                  • FOREIGN KEY
                  • PRIMARY KEY / UNIQUE
                  • CHECK
              • TABLE CONSTRAINT
                • FOREIGN KEY
                • PRIMARY KEY
                • CHECK CONSTRAINT
                • CHECK
                • CONNECTION
                • DEFAULT
        • CREATE
          • FUNCTION
            • SCALAR
            • INLINE TABLE-VALUED
            • MULTI-STATEMENT TABLE-VALUED
      • Built-in functions
        • SnowConvert custom UDFs
          • IS_DATE_UDF
          • IS_MEMBER_UDF
          • IS_NUMERIC_UDF
          • OPENXML UDF
          • PARSE_NAME_UDF
          • PAT_INDEX_UDF
          • STR UDF
          • SWITCH_OFFSET_UDF
        • Aggregate functions
          • COUNT
          • COUNT_BIG
          • SUM
        • Analytic Functions
          • LAG
        • Conversion functions
          • CONVERT
          • TRY_CONVERT
        • Data Type functions
          • DATALENGTH
        • Date & Time functions
          • AT TIME ZONE
          • SWITCHOFFSET
          • DATEADD
          • DATEDIFF
          • DATEPART
          • DATEFROMPARTS
          • DATENAME
          • DAY
          • EOMONTH
          • GETDATE
          • MONTH
          • SYSDATETIME
          • SYSUTCDATETIME
          • YEAR
        • Logical functions
          • IIF
        • Mathematical functions
          • ABS
          • ACOS
            • ACOS in JS
          • ASIN
            • ASIN in JS
          • ATAN
            • ATAN in JS
          • ATN2
            • ATAN2 in JS
          • AVG
          • CEILING
          • COS
            • COS in JS
          • COT
            • COT in JS
          • DEGREES
            • DEGREES in JS
          • EXP
            • EXP in JS
          • FLOOR
          • LOG
            • LOG in JS
          • LOG10
            • LOG10 in JS
          • PI
            • PI in JS
          • POWER
            • POW in JS
          • SQUARE
          • STDEV
          • STDEVP
          • VAR
          • POWER
          • RADIANS
            • RADIANS in JS
          • ROUND
          • SQRT
        • Metadata functions
          • DB_NAME
          • OBJECT_ID
        • Ranking functions
          • DENSE_RANK
          • RANK
          • ROW_NUMBER
        • String functions
          • ASCII
            • ASCII in JS
          • CHAR
          • CHARINDEX
          • COALESCE
          • CONCAT
          • CONCAT_WS
            • Join in JS
          • DIFFERENCE
            • DIFFERENCE in JS
          • FORMAT
            • FORMAT in JS
          • LEFT
          • LEN
          • LOWER
          • LTRIM
            • LTRIM in JS
          • NCHAR
          • PATINDEX
            • search in JS
          • QUOTENAME
            • QUOTENAME in JS
          • REPLACE
          • REPLICATE
          • REVERSE
            • reverse in JS
          • RIGHT
          • RTRIM
          • SOUNDEX
            • SOUNDEX in JS
          • SPACE
          • STR
            • STR in JS
          • STRING_ESCAPE
            • stringify in JS
          • SUBSTRING
          • TRIM
            • trim in JS
          • UPPER
        • System functions
          • FORMATMESSAGE
            • FORMAT_MESSAGE_UDF
          • ISNULL
          • NEWID
          • NULLIF
        • XML Functions
          • Value
          • Query
      • Built-in procedures
        • Custom User Defined Procedures
          • SP_ADDEXTENDEDPROPERTY_UDP
          • THROW_UDP
      • Snowflake Scripting
        • CREATE PROCEDURE
        • CASE
        • CURSOR
        • DECLARE
        • EXECUTE
        • IF
        • SET
        • DMLs
        • CALL
        • WHILE
        • DROPs
        • BEGIN and COMMIT Transaction
        • OUTPUT PARAMETERS
        • LABEL and GOTO
        • SELECT
        • TRY CATCH
        • THROW
      • System Tables
        • SYS.FOREIGN_KEYS
      • Queries
        • TOP
  • ANSI SQL
    • Translation Reference
      • Data Types
        • Interval
      • Statements
        • CREATE TABLE
          • Basic Table
          • Table Scope
          • Column Definition
            • Character Set
            • Identity Column Specification
            • Column Constraint Definition
            • Collate Clause
          • Table Content Source
            • Like Table
            • As SubQuery
          • Table Options
            • Cluster By
            • On Commit
            • With System Versioning
        • INSERT
          • FROM SUBQUERY
        • CREATE VIEW
          • Basic View
          • Recursive Clause
          • As Select
        • Type Casts
  • For PostgreSQL
    • Translation Reference
      • General Language Elements
        • SET SEARCH PATH
        • GET DIAGNOSTICS - ROW_COUNT
      • Data Types
        • Unknown
      • Statements
        • ALTER FUNCTION
          • OWNER TO
        • SELECT STATEMENT
          • DISTINCT
          • LIMIT and OFFSET
        • ALTER TABLE
          • ADD Table Constraint
          • OWNER TO
        • COMMENT ON
        • CREATE TABLE
          • Table Constraint
            • Check Constraint
            • Unique Constraint
            • Primary Key Constraint
            • Exclude Constraint
            • Foreign Key Constraint
        • DELETE
          • Using clause
        • TRUNCATE
        • IF STATEMENT
        • WHILE STATEMENT
        • CURSOR DECLARATION
        • FOR STATEMENT
        • LOOP STATEMENT
        • Assign
        • EXECUTE
        • PERFORM
        • EXIT
        • SELECT INTO
      • Built-in functions
        • Aggregate Functions
          • Count
          • Max
          • Min
          • Sum
        • Window Functions
          • Row Number
        • Conditional Functions
          • Coalesce
        • Date/Time Functions
          • Age
          • Clock Timestamp
          • Date Trunc
          • Now
        • Mathematical Functions
          • Abs
        • String Functions
          • Btrim
          • Char Length
          • Length
          • Lower
          • Ltrim
          • Lpad
          • Position
          • Replace
          • Rpad
          • Rtrim
          • Substring/Substr
          • Upper
        • Data Type Formatting Functions
          • To Char
          • To Timestamp
      • Snowflake Scripting
        • Declare
      • Predicates
        • LIKE
  • For IBM DB2
    • Translation Reference
      • Statements
        • CREATE VIEW
          • OF type-name
          • WITH CHECK OPTION
          • WITH ROW MOVEMENT
        • SELECT
          • fullselect & subselect
            • From Clause
              • SINGLE TABLE REFERENCE
              • SINGLE VIEW REFERENCE
              • Single Nickname Reference
              • ONLY TABLE REFERENCE
              • OUTER TABLE REFERENCE
              • Analyze Table Expression
              • Nested Table Expression
              • Data Change Table Reference
              • Table Function Reference
              • Collection Derived Table
              • Xml table expression
              • Joined Table
              • External Table Reference
            • Values Clause
            • Having Clause
            • Order by Clause
          • Read only Clause
          • Update Clause
          • Optimize for Clause
          • Isolation Clause
          • Concurrent access resolution Clause
          • Offset Clause
          • Fetch Clause
        • INSERT STATEMENT
        • UPDATE STATEMENT
          • Update Target
          • Period Clause
          • Correlation Clause
          • Include Columns
          • Assignment Clause
          • From and Where Clause
          • Order By
          • Offset
          • Fetch
          • With Clause
          • Skip Locked
          • Wait Option
        • DELETE STATEMENT
          • Delete Target
          • Common Table Expresion
          • Period Clause
          • Correlation Clause
          • Include Columns
          • Assignment Clause
          • Where Clause
          • Order By
          • Offset
          • Fetch
          • With Clause
          • Wait Option
          • Skip Locked
        • CREATE TABLE
          • Content Source
            • Element List
              • Column Definition
                • Data Type
                • Column Options
                  • NOT NULL
                  • LOB OPTIONS
                  • SCOPE
                  • CONSTRAINT
                  • D/G CLAUSE
                    • Default Clause
                    • Generated Clause
                  • INLINE LENGTH
                  • COMPRESS
                  • SECURED
                  • HIDDEN
              • Period Definition
              • Unique Constraint
                • ENFORCED
                • QUERY OPTIMIZATION
                • WITHOUT OVERLAPS
              • Referential Constraint
              • Check Constraint
            • Of Type
            • Like Table
            • As Result Table
            • Materialized Query Definition
            • Staging Table Definition
          • Table Options
            • Organize By
            • Data Capture
            • Tablespace Clause
              • In Tablespace
              • Index In
              • Long In
            • Distribution Clause
            • Partitioning Clause
            • Compression Options
            • With Restrict on Drop
            • Not Logged Initially
            • CCSID
            • Security Policy
            • Options
      • Predicates
        • XMLEXISTS Predicate
        • VALIDATED Predicate
        • TYPE Predicate
        • Basic Predicate
        • Boolean Predicate
        • Quantified Predicate
        • JSON_EXISTS
        • OVERLAPS
        • LIKE Predicate
        • Null Predicate
        • REGEXP_LIKE Predicate
  • For Greenplum
    • Translation Reference
      • General Language Elements
      • Data Types
      • Statements
        • Comment On
        • CREATE INDEX
        • RAISE STATEMENT
        • CREATE TABLE
          • Table Constraint
          • Distributed Clause
          • Encoding Clause
          • With Clause
        • DELETE
        • TRUNCATE
        • CREATE EXTERNAL TABLE
        • CREATE FUNCTION
          • When Language is SQL
          • When Language is PLPGSQL
          • Output parameter
        • ALTER TABLE
        • ALTER EXTERNAL TABLE
        • EXECUTE
        • EXIT
      • Built-in functions
      • Snowflake Scripting
        • Declare
  • For Amazon Redshift
    • Translation Reference
      • General Language Elements
      • Data Types
      • Statements
        • ALTER TABLE
        • CREATE VIEW
        • CREATE MATERIALIZED VIEW
        • DELETE
        • EXECUTE
        • EXIT
        • CREATE TABLE
          • Column Attributes
            • DEFAULT
            • IDENTITY
            • GENERATED BY DEFAULT AS IDENTITY
            • ENCODE
            • DISTKEY
            • COLLATE
            • SORTKEY
          • Column Constraints
            • NOT NULL | NULL
            • UNIQUE | PRIMARY KEY
            • REFERENCES
          • Table Attributes
            • DISTSTYLE
            • DISTKEY
            • SORTKEY
            • ENCODE
          • Table Constraints
            • UNIQUE
            • PRIMARY KEY
            • FOREIGN KEY
      • Built-in functions
  • For Apache Hive
    • Translation Reference
      • Built-in functions
      • Data Types
      • DDL
      • General Language Elements
      • Hive Commands
        • Set
      • Reserved & Non-Reserved Keywords
      • Statements
        • Analyze Table
        • Create Table
          • Table Scope
            • If Not Exists
            • Temporary
            • External
          • Column Definition
          • Constraint Definition
          • Table Clauses
            • Comment
            • Partitioned By
            • Clustered By
            • Skewed By
            • Row Format
            • Stored As
            • Location
            • Table Properties
        • Create Table Like
        • Drop Table
  • For Vertica
    • Translation Reference
      • General Language Elements
      • Data Types
      • Statements
      • Built-in functions
  • For Google BigQuery
    • Translation Reference
      • General Language Elements
      • Identifier differences between BigQuery and Snowflake
      • Data Types
        • ANY TYPE
        • ARRAY<T>
        • BYTES
        • GEOGRAPHY
        • INTERVAL
        • JSON
        • STRUCT
        • TIMESTAMP
      • Statements
        • SELECT
          • FROM
        • CREATE FUNCTION
        • CREATE TABLE
          • TABLE SCOPE
            • OR REPLACE
            • TEMP/TEMPORARY
            • IF NOT EXISTS
          • COLUMN DEFINITION
          • CONSTRAINT DEFINITION
          • TABLE OPTIONS
            • DEFAULT COLLATE
            • PARTITION BY
            • CLUSTER BY
            • OPTIONS CLAUSE
            • AS query_statement
        • CREATE TABLE LIKE
        • CREATE TABLE COPY
        • CREATE TABLE CLONE
        • CREATE SNAPSHOT TABLE
        • CREATE EXTERNAL TABLE
        • CREATE VIEW
        • CREATE MATERIALIZED VIEW
        • CREATE SCHEMA
        • CREATE TABLE FUNCTION
        • CREATE PROCEDURE
        • REPEAT STATEMENT
        • WHILE STATEMENT
      • Procedural Language
        • DECLARE
        • CASE
        • SET
        • BEGIN ... END
        • BEGIN...EXCEPTION...END
        • IF
      • Built-in functions
        • Bytes Functions
          • FROM_HEX
          • FROM_BASE64
        • Geography Functions
          • ST_GEOGFROMTEXT
          • ST_GEOGPOINT
  • FOR SPARK (SCALA)
    • Translation Reference
      • SparkSession
        • Builder
        • Read
      • DataFrame
        • Write
      • Column
      • Functions
        • ltrim
        • rtrim
        • trim
      • Dataset
      • Window
      • Operators
        • SQRT
        • SQRT in JS
        • SQUARE
        • SQUARE in JS
        • TAN
        • TAN in JS
      • Import statements
      • Types
        • Column => Column
        • DataFrame => DataFrame
        • Dataset => DataFrame
        • SparkSession => Session
  • FOR SPARK SQL
    • Translation Reference
      • SQL Translation Reference
        • DDL
          • Create Table
            • Using
        • DML
          • Merge
          • Select Statement
            • Distinct
            • Values
            • Join
            • Where
            • Group By
            • Union
        • Data Types
  • FOR PYSPARK (PYTHON)
    • Translation Reference
      • column
      • dataframe
      • functions
        • struct
      • group
      • Import Statements
      • session
        • appName
        • SparkConf
        • SQLContext
        • HiveContext
        • SparkContext
      • RDD
      • readwriter
        • Format/Load
      • types
      • window
      • udf
      • SparkContext
      • StructType
  • General
    • Extensibility in SnowConvert
      • Additional Translation Rules
        • Technical Details
        • Working with ASTs
        • Extensibility API
          • SqlFunctionExprExtensions
          • BaseTranslationRule'2
          • BaseTranslationRule'3
        • Example
  • Assessment Properties
Powered by GitBook
On this page

Was this helpful?

  1. FOR SPARK SQL
  2. Translation Reference
  3. SQL Translation Reference
  4. DML

Select Statement

DistinctValuesJoinWhereGroup ByUnion
PreviousMergeNextDistinct

Was this helpful?