Concept

Result set

In databases, a result set is the set of results returned by a query. In SQL, it is the result of a SELECT query on a table or view and is itself a non-permanent table of rows, and could include metadata about the query such as the column names, and the types and sizes of each column. Depending on the database system, the number of rows in the result set may or may not be known. Usually, this number is not known up front because the result set is built on-the-fly. A cursor can be used by client applications to fetch a few rows of the result set at a time.

READ ONLY RESULTSET
UPDATABLE RESULTSET read more There is no guarantee that the rows of a result set returned by a SELECT query are in any particular order unless the ORDER BY clause is used in the query, which sorts the rows of the result set in ascending or descending order based on one or more columns.

Official source

https://en.wikipedia.org/wiki/Result_set

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.

Related courses (9)

MATH-106(f): Analysis II

Étudier les concepts fondamentaux d'analyse et le calcul différentiel et intégral des fonctions réelles de plusieurs variables. ...

MATH-101(f): Analysis I

Étudier les concepts fondamentaux d'analyse et le calcul différentiel et intégral des fonctions réelles d'une variable. ...

COM-490: Large-scale data science for real-world data

This hands-on course covers tools and methods used by data scientists, from researching solutions to scaling prototypes on Spark clusters. Students engage with the full data engineering and data science pipeline, from data acquisition to extracting insight ...

Related lectures (16)

Topological spatial queries MOOC: Geographical Information Systems 1

Covers SQL queries for spatial relations and operators in Geographic Information Systems.

Spatial Topological Queries MOOC: Geographical Information Systems 1

Covers SQL queries for exploring spatial relationships and creating new objects.

Limites à l'infini: Suite et fin

Covers the concept of limits at infinity and provides insights into its application.

Related publications (4)

Spatial location of activities and energy consumption of households in France

Vincent Kaufmann

The design of policies and interventions aiming at the reduction of energy consumption requires a good understanding of the underlying social logics. In this perspective, this paper focuses on how the distribution of daily activities at home and away, in various locations, result into different levels of energy consumption in buildings and transportation. This analysis is based on an ad hoc survey of 2000 French households in late 2013. The questionnaire was focused on daily activities, mobility and energy

2016

Spatial location of activities and energy consumption of households in France

Vincent Kaufmann

2016

Range queries in trie-structured overlays

Karl Aberer

Among the open problems in P2P systems, support for non-trivial search predicates, standardized query languages, distributed query processing, query load balancing, and quality of query results have been identified as some of the most relevant issues. This paper describes how range queries as an important non-trivial search predicate can be supported in a structured overlay network that provides

O(\log{n})

search complexity on top of a trie abstraction. We provide analytical results that show that the pro

2005

Graph Chat

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.

READ ONLY RESULTSET
UPDATABLE RESULTSET read more There is no guarantee that the rows of a result set returned by a SELECT query are in any particular order unless the ORDER BY clause is used in the query, which sorts the rows of the result set in ascending or descending order based on one or more columns.

Official source

https://en.wikipedia.org/wiki/Result_set

About this result

Related courses (9)

MATH-106(f): Analysis II

Étudier les concepts fondamentaux d'analyse et le calcul différentiel et intégral des fonctions réelles de plusieurs variables. ...

MATH-101(f): Analysis I

Étudier les concepts fondamentaux d'analyse et le calcul différentiel et intégral des fonctions réelles d'une variable. ...

COM-490: Large-scale data science for real-world data

Related lectures (16)

Topological spatial queries MOOC: Geographical Information Systems 1

Covers SQL queries for spatial relations and operators in Geographic Information Systems.

Spatial Topological Queries MOOC: Geographical Information Systems 1

Covers SQL queries for exploring spatial relationships and creating new objects.

Limites à l'infini: Suite et fin

Covers the concept of limits at infinity and provides insights into its application.

Related publications (4)

Spatial location of activities and energy consumption of households in France

Vincent Kaufmann

2016

Spatial location of activities and energy consumption of households in France

Vincent Kaufmann

2016

Range queries in trie-structured overlays

Karl Aberer

O(\log{n})

search complexity on top of a trie abstraction. We provide analytical results that show that the pro

2005

Related people (3)

Kamil Sedlák

Teaching & PhD PhD Students Daniel Louis Arthur Biek Courses Fusion and industrial plasma technologies PHYS-632 The course provides an overview of the technologies that are essential for fusion developments and for industrial plasmaapplications, highlighting the synergies between the two fields. The aim is to provide a combined theoretical andexperimental background to the various topics.

Michael Christoph Gastpar

Michael Gastpar is a (full) Professor at EPFL. From 2003 to 2011, he was a professor at the University of California at Berkeley, earning his tenure in 2008. He received his Dipl. El.-Ing. degree from ETH Zürich, Switzerland, in 1997 and his MS degree from the University of Illinois at Urbana-Champaign, IL, USA, in 1999. He defended his doctoral thesis at EPFL on Santa Claus day, 2002. He was also a (full) Professor at Delft University of Technology, The Netherlands. His research interests are in network information theory and related coding and signal processing techniques, with applications to sensor networks and neuroscience. He is a Fellow of the IEEE. He is the co-recipient of the 2013 Communications Society & Information Theory Society Joint Paper Award. He was an Information Theory Society Distinguished Lecturer (2009-2011). He won an ERC Starting Grant in 2010, an Okawa Foundation Research Grant in 2008, an NSF CAREER award in 2004, and the 2002 EPFL Best Thesis Award. He has served as an Associate Editor for Shannon Theory for the IEEE Transactions on Information Theory (2008-11), and as Technical Program Committee Co-Chair for the 2010 International Symposium on Information Theory, Austin, TX.

Jean-Paul Richard Kneib

Expertise Cosmology, Gravitational Lensing, Redshift Survey, First Galaxies, Cluster of Galaxies, Fiber-positioner robotic system, Radio Astronomy, Space Sustainibility Current work

Former Principal investigator of the SDSS-IV eBOSS project. This is an international project assembling more than 150 participants located mainly in Europe, USA and China. This project will observe 1.5 million galaxy and quasars over 2014-2020 to accurately measure the expansion history of the Universe. * Member of the DESI co

Related concepts (1)

Java Database Connectivity

Java Database Connectivity (JDBC) is an application programming interface (API) for the Java programming language which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. It is part of the Java Standard Edition platform, from Oracle Corporation. It provides methods to query and update data in a database, and is oriented toward relational databases. A JDBC-to-ODBC bridge enables connections to any ODBC-accessible data source in the Java virtual machine (JVM) host environment.

Related people (3)

Kamil Sedlák

Michael Christoph Gastpar

Jean-Paul Richard Kneib

Expertise Cosmology, Gravitational Lensing, Redshift Survey, First Galaxies, Cluster of Galaxies, Fiber-positioner robotic system, Radio Astronomy, Space Sustainibility Current work

Former Principal investigator of the SDSS-IV eBOSS project. This is an international project assembling more than 150 participants located mainly in Europe, USA and China. This project will observe 1.5 million galaxy and quasars over 2014-2020 to accurately measure the expansion history of the Universe. * Member of the DESI co