Amazon Redshift related posts in this category

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 »

Redshift ORDER BY

Redshift ORDER BY is used to sort the output rows in the result set. You can sort the output rows in ascending or descending order. By default, the sorting order is ascending. You can sort output rows on the basis of single column, multiple columns or even combination of ascending and descending for different columns.

Redshift ORDER BY Read More »

Redshift Select

In this post, I will show you how you can use SELECT statements in Redshift to query data from tables. SELECT is used to fetch one or more columns directly from the table. The SELECT is one of the most simple and yet challenging at times statement in Redshift. SELECT can become complex while creating

Redshift Select Read More »