Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Install
Faster access than browser!
 

Select (SQL)

Index Select (SQL)

The SQL SELECT statement returns a result set of records from one or more tables. [1]

46 relations: Adaptive Server Enterprise, Aggregate function, Alias (SQL), Couchbase Server, Cursor (databases), Declarative programming, Firebird (database server), H2 (DBMS), Having (SQL), Hierarchical and recursive queries in SQL, Hierarchical database model, HSQLDB, IBM Db2, IBM Informix, Ingres (database), InterBase, International Organization for Standardization, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, Nondeterministic algorithm, Oracle Database, Order by, Polyhedra DBMS, PostgreSQL, Projection (relational algebra), Query language, Query optimization, Query plan, Relational algebra, Result set, SAP IQ, Selection (relational algebra), SQL, SQL Anywhere, SQL:2003, SQL:2008, SQLite, Table (database), Teradata, Vertica, View (SQL), Where (SQL), Window function.

Adaptive Server Enterprise

SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model database server product for businesses developed by Sybase Corporation which became part of SAP AG.

New!!: Select (SQL) and Adaptive Server Enterprise · See more »

Aggregate function

In database management an aggregate function is a function where the values of multiple rows are grouped together to form a single value of more significant meaning or measurement such as a set, a bag or a list.

New!!: Select (SQL) and Aggregate function · See more »

Alias (SQL)

An alias is a feature of SQL that is supported by most, if not all, relational database management systems (RDBMSs).

New!!: Select (SQL) and Alias (SQL) · See more »

Couchbase Server

Couchbase Server, originally known as Membase, is an open-source, distributed (shared-nothing architecture) multi-model NoSQL document-oriented database software package that is optimized for interactive applications.

New!!: Select (SQL) and Couchbase Server · See more »

Cursor (databases)

In computer science, a database cursor is a control structure that enables traversal over the records in a database.

New!!: Select (SQL) and Cursor (databases) · See more »

Declarative programming

In computer science, declarative programming is a programming paradigm—a style of building the structure and elements of computer programs—that expresses the logic of a computation without describing its control flow.

New!!: Select (SQL) and Declarative programming · See more »

Firebird (database server)

Firebird is an open source SQL relational database management system that "runs on Linux, Microsoft Windows, and several Unix platforms".

New!!: Select (SQL) and Firebird (database server) · See more »

H2 (DBMS)

H2 is a relational database management system written in Java.

New!!: Select (SQL) and H2 (DBMS) · See more »

Having (SQL)

A HAVING clause in SQL specifies that an SQL SELECT statement should only return rows where aggregate values meet the specified conditions.

New!!: Select (SQL) and Having (SQL) · See more »

Hierarchical and recursive queries in SQL

A hierarchical query is a type of SQL query that handles hierarchical model data.

New!!: Select (SQL) and Hierarchical and recursive queries in SQL · See more »

Hierarchical database model

A hierarchical database model is a data model in which the data is organized into a tree-like structure.

New!!: Select (SQL) and Hierarchical database model · See more »

HSQLDB

HSQLDB (Hyper SQL Database) is a relational database management system written in Java.

New!!: Select (SQL) and HSQLDB · See more »

IBM Db2

IBM Db2 contains database-server products developed by IBM.

New!!: Select (SQL) and IBM Db2 · See more »

IBM Informix

IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings.

New!!: Select (SQL) and IBM Informix · See more »

Ingres (database)

Ingres Database is a commercially supported, open-source SQL relational database management system intended to support large commercial and government applications.

New!!: Select (SQL) and Ingres (database) · See more »

InterBase

InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies.

New!!: Select (SQL) and InterBase · See more »

International Organization for Standardization

The International Organization for Standardization (ISO) is an international standard-setting body composed of representatives from various national standards organizations.

New!!: Select (SQL) and International Organization for Standardization · See more »

Microsoft Access

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

New!!: Select (SQL) and Microsoft Access · See more »

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft.

New!!: Select (SQL) and Microsoft SQL Server · See more »

Mimer SQL

Mimer SQL is an SQL-based relational database management system produced by the Swedish company Mimer Information Technology AB (Mimer AB), formerly known as Upright Database Technology AB.

New!!: Select (SQL) and Mimer SQL · See more »

MySQL

MySQL ("My S-Q-L") is an open-source relational database management system (RDBMS).

New!!: Select (SQL) and MySQL · See more »

Netezza

IBM Netezza (pronounced ne-teez-a) designs and markets high-performance data warehouse appliances and advanced analytics applications for uses including enterprise data warehousing, business intelligence, predictive analytics and business continuity planning.

New!!: Select (SQL) and Netezza · See more »

Nondeterministic algorithm

In computer science, a nondeterministic algorithm is an algorithm that, even for the same input, can exhibit different behaviors on different runs, as opposed to a deterministic algorithm.

New!!: Select (SQL) and Nondeterministic algorithm · See more »

Oracle Database

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

New!!: Select (SQL) and Oracle Database · See more »

Order by

An ORDER BY clause in SQL specifies that a SQL SELECT statement returns a result set with the rows being sorted by the values of one or more columns.

New!!: Select (SQL) and Order by · See more »

Polyhedra DBMS

Polyhedra is a family of relational database management systems offered by ENEA AB, a Swedish company.

New!!: Select (SQL) and Polyhedra DBMS · See more »

PostgreSQL

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

New!!: Select (SQL) and PostgreSQL · See more »

Projection (relational algebra)

In relational algebra, a projection is a unary operation written as \Pi_(R) where a_1,...,a_n is a set of attribute names.

New!!: Select (SQL) and Projection (relational algebra) · See more »

Query language

Query languages or data query languages (DQLs) are computer languages used to make queries in databases and information systems.

New!!: Select (SQL) and Query language · See more »

Query optimization

Query optimization is a function of many relational database management systems.

New!!: Select (SQL) and Query optimization · See more »

Query plan

A query plan (or query execution plan) is an ordered set of steps used to access data in a SQL relational database management system.

New!!: Select (SQL) and Query plan · See more »

Relational algebra

Relational algebra, first created by Edgar F. Codd while at IBM, is a family of algebras with a well-founded semantics used for modelling the data stored in relational databases, and defining queries on it.

New!!: Select (SQL) and Relational algebra · See more »

Result set

A SQL result set is a set of rows from a database, as well as metadata about the query such as the column names, and the types and sizes of each column.

New!!: Select (SQL) and Result set · See more »

SAP IQ

SAP IQ (formerly known as SAP Sybase IQ or Sybase IQ) is a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.

New!!: Select (SQL) and SAP IQ · See more »

Selection (relational algebra)

In relational algebra, a selection (sometimes called a restriction in reference to E.F. Codd's 1970 paper and not, contrary to a popular belief, to avoid confusion with SQL's use of SELECT, since Codd's article predates the existence of SQL) is a unary operation that denotes a subset of a relation.

New!!: Select (SQL) and Selection (relational algebra) · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: Select (SQL) and SQL · See more »

SQL Anywhere

SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP.

New!!: Select (SQL) and SQL Anywhere · See more »

SQL:2003

SQL:2003 is the fourth revision of the SQL database query language.

New!!: Select (SQL) and SQL:2003 · See more »

SQL:2008

SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language.

New!!: Select (SQL) and SQL:2008 · See more »

SQLite

SQLite is a relational database management system contained in a C programming library.

New!!: Select (SQL) and SQLite · See more »

Table (database)

A table is a collection of related data held in a structured format within a database.

New!!: Select (SQL) and Table (database) · See more »

Teradata

Teradata Corporation is a provider of database and analytics-related products and services.

New!!: Select (SQL) and Teradata · See more »

Vertica

Vertica Systems is an analytic database management software company.

New!!: Select (SQL) and Vertica · See more »

View (SQL)

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.

New!!: Select (SQL) and View (SQL) · See more »

Where (SQL)

A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria.

New!!: Select (SQL) and Where (SQL) · See more »

Window function

In signal processing, a window function (also known as an apodization function or tapering function) is a mathematical function that is zero-valued outside of some chosen interval.

New!!: Select (SQL) and Window function · See more »

Redirects here:

SQL query, Select sql, Sql select, Window function (SQL).

References

[1] https://en.wikipedia.org/wiki/Select_(SQL)

OutgoingIncoming
Hey! We are on Facebook now! »