Writing SQL Statements

Writing SQL Statements :

• SQL statements are not case-sensitive
• SQL statements can be on one or more lines
• Keywords cannot be abbreviated or split across lines
• Clauses are usually placed on separate lines
• Indents are used to enhance readability
• In SQL Query Tool(PGADMIN3), SQL statements can optionally be terminated by a semicolon (;)
• Semicolons are required if you execute multiple SQL statements
• In PSQL Client, you are required to end each SQL statement with a semicolon (;)