6.What is the function of SELECT commond
Answers
Answer:
The SQL SELECT statement returns a result set of records, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database tables or database views. In most applications, SELECT is the most commonly used data manipulation language (DML) command.
MARK ME AS BRAINLIEST ANSWER
Answer:
The SQL SELECT statement returns a result set of records, from one or more tables.
A SELECT statement is retives zero or more rows from one or more database tables or database views. In most applications, SELECT is the most commonly used data manipulation language (DML) command. As SQL is a declarative programming language,SELECT 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 functionally is called the "query optimizer"as it responsible for finding the best possible execution plan for the query, within applicable constraints.
The SELECT statement his many optional clauses:
FROM specifies from which table to get the data.
WHERE specifies which rows to retrieve.
GROUP BY groups rows sharing a property that an aggregate function can be applied to each group.
HAVING select among the groups defined by the GROUP BY clause.
ORDER BY specifies how to order the returned rows.
AS provides an alias which can be used to temporarily rename tables or columns.