To start with, the SQL Server Select Statement is designed to select data or a result set of records from a table or more tables. Then, the result of such process is stored in a result table which is known the result-set.
To get more specific, the SQL Server Select Statement has the capability to retrieve from zero or more rows that come from more base tables or even from impermanent tables. When other applications are being employed, SQL Server Select is ordinarily use in operating Data Manipulation Language command.
Since SQL Server Select is considered as non-procedural language, the Select inquiries have to be specified with a result set without detailing the procedures of calculation. It only translates inquiry into “query plan” which is then left within the system of database or the query optimizer.
For the SQL Server Select Statement discretionary clauses it has clauses such as: WHERE, GROUB BY, HAVING, and ORDER BY. In the WHERE clause, it identifies which among the rows should be retrieved. In GROUP BY clause, what happens is that, groups’ rows share properties to prompt aggregate function (function that computes single result value from a collection of input values like set). Such function is applicable to each group.
For the HAVING clause, it provides the capacity to select inquiry from among the groups which is in fact identified by the clause GROUP BY. Lastly, the ORDER BY clause it what identifies an order so that the SELECT statement has to return the rows that received the query.