Database Reference
In-Depth Information
The HAVING clause is similar to the WHERE clause in that it defines a search
condition. HAVING Supports All of WHERE's Operators
ORDER BY Clause
It is used to add sorting parameters, allowing rows to be rearranged in a specified order.
Sorting query results helps make your report more readable and useful. For example, it is
very useful to list people in alphabetical order by last name. The ORDER BY clause of the
SELECT statement provides sorting capability. The ORDER BY clause appears after the
WHERE clause. The ORDER BY clause is an optional clause, as is the WHERE clause.
Example: Show data according to names
SELECT * FROM Staff
OREDER BY Name ;
SELECT Clause Ordering
SELECT
Clause
SELECT
WHERE
GROUP BY HAVING ORDER BY
Clause
Description
Columns or expressions to be returned Row-level filtering
Group specification
Group-level filtering
Output sort order
7.3.3 Manipulation on Tables
Operators can be divided into several groups. Arithmetic operators allow things like 1 + 1
or 5 * 3, where + and * are the arithmetic operators. Logical operators allow merging of
multiple expressions.
Arithmetic Operators
Various Arithmetic Operators are used while seeing records from a table.
Following are Data manipulation operators:
