Distinct. You can remove the duplicate rows and create a distinct query.

Null Treated Low. You can sort the columns in a query based on the columns having null values. You can sort the columns only in a query. The sort order is not honored on the Redshift target.