The HAVING clause can be used along with GROUP BY clause in the SELECT statement to place condition on groups and can include aggregate functions on them. For example to count the number of Male and Female students belonging to Chennai.
SELECT Gender, count(*) FROM Student GROUP BY Gender HAVING Place = 'Chennai',

SELECT < column-names > FROM < table-name > GROUP BY < column-name > HAVING condition];

This constraint declares a field as a Primary key which helps to uniquely identify a record. The primary key does not allow NULL values and therefore a field declared as primary key must have the NOT NULL constraint.

The ORDER BY clause is used as :
SELECT < column-name > [, < columnname >, .... ]
FROM < table-name >ORDER BY < column1 >,< column2 >, ... ASC| DESC ;

The NULL value in a field can be searched in a table using the ISNULL in the WHERE clause. For example to list all the students whose Age contains no value, the command is used as: SELECT * FROM Student WHERE Age IS NULL;

IN Keyword	NOT IN keyword
The IN keyword is used to specify a list of values which must be matched with the record values. In other words it is used to compare a column with more than one value. It is similar to an OR condition.	The NOT IN keyword displays only those records that do not match in the list

BETWEEN	NOT BETWEEN
The BETWEEN keyword defines a range of values the record must fall into to make the condition true.	The NOT BETWEEN is reverse of the BETWEEN operator where the records not satisfying the condition are displayed.

Transactional Control Language (TCL) commands are used to manage transactions in the database. These are used to manage the changes made to the data in a table by DML statements.

(i) Insert: Inserts data into a table
(ii) Update: Updates the existing data within a table.
(iii) Delete: Deletes all records from a table, but not the space occupied by them.

The DML is basically of two types:
(i) Procedural DML - Requires a user to specify what data is needed and how to get it.
(ii) Non-Procedural DML - Requires a user to specify what data is needed without specifying how to get it.

SQL	MYSQL
Structured Query Language is a language used for accessing database	MySQL is a database | accessing databases. management system, like SQL Server, Oracle, Informix,postgres,etc.
SQL is a DBMS	MySQL is a RDBMS

 

Command Description Component Insert Inserts data into a table DML Create To create tables in the database DML  

Table Constraints	column constraints
Table constraint is apply to a group of one or more columns.	Column constraint can be apply only to individual columns.

S.No	Unique Key Constraint	Primary Key Constraint
(i)	This constraint ensures that no two rows have the same value in the specified columns.	This constraint declares a field as a Primary Key which helps to uniquely identify a record.
(ii)	The UNIQUE constraint can be Create applied only to fields that have also been declared as NOT NULL.	The Primary Key does not allow NULL values.

SELECT * FROM Student WHERE Age <= 18 ORDER BY Name;