Lecture

Aggregation queries and sorting

Description

This lecture introduces the logics of aggregation queries and sorting of the result in Geographic Information Systems. It covers aggregation functions like SUM, COUNT, AVG, MIN, and MAX, as well as the GROUP BY and HAVING clauses. The instructor demonstrates how to write aggregation queries, sort query results, and limit the number of records returned.

In MOOCs (2)

Instructor

reprehenderit do quis

Sit sunt exercitation veniam amet id voluptate adipisicing officia officia dolore aute. Velit proident ex tempor anim qui. Lorem sit velit reprehenderit in consectetur eu exercitation et consequat Lorem. Nostrud exercitation enim elit excepteur deserunt. Ullamco velit magna eu laborum id fugiat proident. Sunt et fugiat exercitation veniam cillum occaecat nostrud commodo.

Official source

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

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

Mathematics

Algebra: Representation theory

Computer engineering

Databases: Relational databases

Theoretical computer science

Algorithms and data structures: Analysis of algorithms

Related lectures (45)

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.