SQL: DELETE Statement
The Delete statement allows you to delete a single record or multiple records from a table. After you remove records…
SQL: INSERT Statement
Data is added to tables by using the Insert statement. The Insert Into statement can be used to append a…
SQL: UPDATE Statement
In daily use, a database is a constantly changing store of data. The SQL commands which are used to modify…
SQL: IN Operator
We’ve seen that Between defines a range of values to check against for inclusion or exclusion from the result table.…
SQL: BETWEEN … AND…
The Between keyword allows you to define a predicate in the form of a range. If a column value for…
SQL: HAVING Clause
The Having clause is optional and used in combination with the Group By clause. It is similar to the Where…
SQL: GROUP BY
The aggregate functions, such as Sum, Count, Min, or Max are used to produce grand totals. Values output by them…
SQL: ORDER BY
In all the queries we’ve seen so far, the rows in the result table have not been ordered in any…
SQL: AND & OR conditions
The scope of the Where clause and the operators used with it can be extended by using the logical operators…
SQL: WHERE Clause
One of the most useful feature of the SQL query, since it allows you to selectively retrieve only those rows…