All the SQL statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW and all the statements end with a semicolon (;).

Example

• SELECT emp_name, hire_date, salary FROM employees WHERE salary > 5000;

  For better readability you can also write the same statement, as follow:

  Example:

  SELECT emp_name, hire_date, salary 

  FROM employees 

  WHERE salary > 5000;

Case Sensitivity in SQL

Example:

SELECT emp_name, hire_date, salary FROM employees;

The same statement can also be written, as follow:

Example:

select emp_name, hire_date, salary from employees;

SQL Comments

SQL support single-line as well as multi-line comments. To write a single-line comment start the line with two consecutive hyphens (--).

Example:

-- Select all the employees

SELECT * FROM employees;