Lecture

Aggregation Request and Result Sorting

Description

This lecture covers the main aggregation functions for statistical calculations on data sets or subsets, including grouping clauses to extract statistical values per data group. It also explains how to filter group queries using HAVING queries to extract the most relevant elements. Additionally, it demonstrates how to use sorting functions with the ORDER BY keyword and limit the number of objects displayed in a result.

In MOOCs (2)

Instructor

ipsum duis consequat qui

Non pariatur esse nostrud eiusmod consequat. Veniam nulla velit cupidatat tempor magna cupidatat mollit nulla amet proident officia cillum cupidatat sunt. Consectetur dolore culpa excepteur exercitation occaecat deserunt aliqua cupidatat velit non mollit duis nostrud consequat. Ipsum qui quis ipsum veniam qui non velit laborum enim duis ut culpa mollit deserunt. Voluptate nostrud sit ipsum labore officia incididunt do do ad sunt.

Official source

https://mediaspace.epfl.ch/media/0_oea84ab5

About this result

This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.

Ontological neighbourhood

Theoretical computer science

Algorithms and data structures: Analysis of algorithms

Related lectures (28)

Graph Chatbot

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.