Retrieving data from a table or view (SELECT command)
Use the SELECT command to retrieve one or more rows, or partial rows, of data from an existing table or view, and to perform grouping functions on the data.
You can use the SELECT command to perform the following actions:
- Retrieve data that matches a specified criteria (scalar SELECT)
- Return a single value that is based on a calculation on a number of rows (aggregate SELECT)
- Group all rows that contain identical values in one or more columns, and perform aggregate functions on the columns (group by SELECT)