Content deleted Content added
Fjerdingen (talk | contribs) m Some minor adjustments, mostly towards ISO SQL terminology. |
more tables.<ref>{{cite web |url=http://msdn2.microsoft.com/en-us/library/ms189499.aspx |title=Transact-SQL Syntax Conventions |author=Microsoft |date=23 May 2023 }}</ref><ref>{{cite web |url=http://dev.mysql.com/doc/refman/5.0/en/select.html|title=SQL SELECT Syntax |author=MySQL}}</ref> A SELECT statement retrieves zero or more rows from one or more database tables or database views. In most applications, <code>SELECT</code> is th... Tags: Reverted references removed Mobile edit Mobile web edit |
||
Line 1:
{{Short description|SQL statement that returns a result set of rows from one or more tables}}
▲A SELECT statement retrieves zero or more rows from one or more [[Database Tables|database tables]] or database [[View (database)|views]]. In most applications, <code>SELECT</code> is the most commonly used [[data manipulation language]] (DML) command. As SQL is a [[declarative programming]] language, <code>SELECT</code> queries specify a result set, but do not specify how to calculate it. The database translates the query into a "[[query plan]]" which may vary between executions, database versions and database software. This functionality is called the "[[query optimizer]]" as it is responsible for finding the best possible execution plan for the query, within applicable constraints.
The SELECT statement has many optional clauses:
| |||