Content deleted Content added
No edit summary |
|||
Line 1:
HI........! A '''SELECT''' statement in [[SQL]] returns a [[result set]] of records from one or more tables.
It is used to retrieve zero or more rows from one or more tables in a database. In most applications, <code>SELECT</code> is the most commonly used [[Data Manipulation Language]] (DML) command. In specifying a <code>SELECT</code> query, the user specifies a description of the desired result set, but they do ''not'' specify what physical operations must be executed to produce that result set. Translating the query into an optimal "query plan" is left to the database system, more specifically to the query optimiser.
| |||