In the following section, some other advanced SQL techniques will be introduced:

• The DISTINCT ON clause, which helps in finding the first records in groups
• Selecting sample data from a big table
• The set returning functions, which are functions that return relations
• LATERAL joins, which allow subqueries to reference each other
• Advanced grouping techniques that can be used in generating reports
• Some special aggregating functions