Redshift Select Distinct

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 […]

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 […]

Redshift ALIAS – Column & Table

In SQL, ALIAS means another name given to objects like columns & tables. You can use column and table aliases to make sql query more readable and easier for developer too to write the query. In most of the cases, […]

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 […]