OverviewHintsWITH clauseSELECT & WHERESELECT DISTINCTWindowing TVFWindow AggregationGroup AggregationOver AggregationJoinsSet OperationsORDER BY clauseLIMIT clauseTop-NWindow Top-NDeduplicationPattern Recognition