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 »
In this post I have shared the key differences between star schema and snowflake schema. Star schema is the most commonly used approach to design & develop data warehouse. It is simple to implement in which we have centralised one or more FACT Tables surrounded by multiple dimension tables. The fact table source keys from …
star schema and snowflake schema in data warehouse Read More »
I have recently changed my team and was working on a project and my business analyst asked me to CREATE A TABLE for some business logic. However when I converted the business logic into SQL I did not see it as a requirement for a new TABLE. In my opinion it should be a VIEW. …
Difference between Table and View in SQL. Is view better than table ? Read More »
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 »
The most common method to fetch previous row value in SQL is by using the LAG function. The LAG function returns the previous row value. Depending on the order by clause the previous row is determined and the column value is returned. catid previous_catid 1 NULL 2 1 3 2 4 3 5 4 6 …
Redshift SELECT Distinct is used to fetch unique rows from the table. DISTINCT is applied to all the columns mentioned in the SELECT clause and not just the first column. The example fetches DISTINCT values for one column in the table catgroup Sports Shows Concerts redshift select distinct multiple columns You can apply DISTINCT on …
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 …
