Redshift Stored Procedure

Redshift Stored Procedure for beginners with example

In this post, we will see how you can create Redshift Stored Procedure with example. We will also talk about redshift stored procedure parameters and dynamic sql in stored procedure. What is a stored procedure ? Stored Procedure (SP) is a database object which encapsulates business transformation logic into one unit. Stored Procedure can consists …

Redshift Stored Procedure for beginners with example Read More »

teradata

25 most important Teradata Date Functions (2022)

25 Teradata Date Functions examples Teradata Date Function Output Description SELECT DATE 2020-10-09 Fetch Current Date SELECT CAST(DATE AS VARCHAR(20)) 20/10/09 SQL Editor may modify the DATE column and display date value in some other format.To Display DATE in actual format use casting. SELECT CAST(DATE AS DATE FORMAT 'Y4-MM-DD') 2020-10-09 Display date in the user …

25 most important Teradata Date Functions (2022) Read More »

SQL

Duplicate rows in SQL

Duplicate rows in the table can result in data quality issues. Sometimes it is ok to have duplicate rows in the table as per business requirement. However if the duplicate rows are loaded into the table accidentally you must remove the duplicate rows. What are duplicate rows in SQL ? When the value of two …

Duplicate rows in SQL Read More »