SQL Code snippets

Teradata SQL

Convert string to date in SQL / Teradata

This code snippet shows how to convert string to date.

View detail
Teradata SQL

Select top N records in SQL / Teradata

In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.

View detail
Hive SQL

Select top N records in SQL / Hive

In different databases, the syntax of selecting top N records are slightly different. They may also differ from ISO standards.

View detail
Hive SQL

Select from dual in SQL / Hive

In Oracle database, you can select from dual table if you only want to return a one row result set. In many other databases, the query engine supports select directly from constant values without specifying a table name. 

View detail
Teradata SQL

Read and parse JSON in SQL / Teradata

JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON. 

View detail
Teradata SQL

Calculate time difference in SQL / Teradata

This code snippet shows how to calculate time differences.

View detail