SQL syntax

• The syntax of the structured query language is a unique set of rules and guidelines, which are not case-sensitive.
• Its Syntax is defined and maintained by ISO and ANSI standards.

Some important points about SQL syntax are:

• You can write the Keywords of SQL in both uppercase and lowercase, but writing the SQL keyword in uppercase improves the readability of the SQL query.
• SQL syntax or statements are dependent on text lines We can place a single SQL statement on one or multiple text lines.
• You can perform most of the action in a database with SQL statements.

SQL statements:

• Most of the actions you need to perform on a database are done with SQL statements.
• SQL statements tell the database what operation you want to perform on the structured data and what information you would like to access from the database.

Example:

SELECT “column_name” FROM “table_name”;

• Each SQL statement begins with any of the SQL keywords and ends with the semicolon(;).
• The semicolon is used for separating the multiple SQL statements which are going to execute in the same call.