local_offer teradata local_offer SQL
OREPLACE functions in Teradata can be used to replace or remove characters from a string. OREPACE is Teradata's extension to ASNI SQL. The usual REPLACE function is not available. ANSI SQL REPLACE function REPLACE function is commonly implemented in many other SQL databases such as ...
local_offer pyspark local_offer spark-2-x local_offer teradata local_offer SQL Server
In my previous article about Connect to SQL Server in Spark (PySpark) , I mentioned the ways t...
local_offer teradata local_offer SQL
Extract sub string from a string is a common operation in data analytics. In Teradata, function SUBSTRING (SUBSTR) and REGEXP_SUBSTR are provided to achieve that. SUBSTR is used to extract string from a specified location while REGEXP_SUBSTR is used to extract string using regular expressions. ...
local_offer teradata local_offer SQL
COALESCE function in Teradata returns NULL if all arguments evaluate to null; otherwise it returns the value of the first non-null argument. NULLIF is to used evaluate two expressions and returns NULL if the two arguments are equal otherwise if returns the first arguments. IS NULL i...
local_offer teradata local_offer SQL
In SQL Server, TRY_CAST function returns a value cast to a specified data type is the cast is successful or null is the cast is not successful. In Teradata, the equivalent function is TRYCAST. Code snippets -- return int 1030 SELECT TRYCAST('01030' AS int); -- retur...
local_offer teradata local_offer SQL
From Teradata 16, LEAD and LAG OLAP functions are supported. The LAG function returns data from a row preceding the current row at a specified offset in a window group; the LEAD function accesses data from a row following the current row at a specified offset in a window group. Scenario ...
local_offer teradata local_offer SQL
In ANSI SQL, you can use DATEADD function to easily add or subtract days/week/months/years from a date as the following code snippet shows: SELECT DATEADD ( ...
local_offer teradata local_offer SQL
In Teradata, Common Table Expression (CTE) is supported as other databases. You can create recursive CTE or use a reference of a CTE to another CTE. However there is a slight differences compared with other databases - The referenced CTE must be present after the referencing CTE. For exampl...
local_offer teradata local_offer SQL
This code snippet shows how to convert string to date in Teradata.
local_offer teradata local_offer SQL
In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.
