- SQL Basics
- SQL Home
- SQL Syntax
- SQL RDBMS
- SQL Databases
- SQL Data Types
- SQL Operators
- SQL Expressions
- SQL Database
- SQL Create Database
- SQL Select Database
- SQL Drop Database
- SQL Table
- SQL Create Table
- SQL Drop Table
- SQL Keywords
- SQL Insert Into
- SQL Select
- SQL Where
- SQL And & Or
- SQL Update
- SQL Delete
- SQL Like
- SQL Select Top
- SQL Group By
- SQL Order By
- SQL Distinct
- SQL In
- SQL Between
- SQL Joins
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Constraints
- SQL Constraints
- SQL Unique
- SQL Not Null
- SQL Primary Key
- SQL Foreign Key
- SQL Check
- SQL Default
- SQL Create Index
- SQL Advance
- SQL Aliases
- SQL Union
- SQL Auto Increment
- SQL Views
- SQL Dates
- SQL Transactions
- SQL Injection
- SQL Test
- SQL Online Test
- Give Online Test
- All Test List
SQL Syntax
Before learning SQL, you must have to understand about the basic syntax of SQL. Here are the general syntax of some SQL clauses and statements. Every SQL statements ends with a semicolon (;).
SQL SELECT Statement Syntax
Here is the syntax of the SQL select statement:
SELECT col1, col2, col3, ..., colN FROM table_name;
To learn more about SQL SELECT statement, refer to SQL Select
SQL INSERT INTO Statement Syntax
Here is the syntax of the SQL INSERT INTO statement:
INSERT INTO table_name(col1, col2, col3, ..., colN) VALUES(val1, val2, val3, ..., valN);
To learn more about SQL INSERT INTO statement, refer to SQL Insert Into
SQL DISTINCT Clause Syntax
Following is the syntax of the SQL DISTINCT clause:
SELECT DISTINCT col1, col2, col3, ...., colN FROM table_name;
To learn more about SQL DISTINCT clause, refer to SQL Distinct
SQL WHERE Clause Syntax
Below is the syntax of the SQL WHERE clause:
SELECT col1, col2, col3, ..., colN FROM table_name WHERE CONDITION;
Refer to SQL Where to learn more about SQL where clause
SQL IN Clause Syntax
The syntax of the SQL IN clause is show here:
SELECT col1, col2, col3, ..., colN FROM table_name WHERE column_name IN (val1, val2, val3, ..., valN);
To learn in detail about SQL IN clause, refer to SQL In
SQL AND/OR Clause Syntax
The syntax of the SQL AND/OR clause is shown below:
SELECT col1, col2, col3, ..., colN FROM table_name WHERE CONDITION-1 {AND|OR} CONDITION-2;
To learn in detail about SQL AND/OR clause then refer to SQL And & Or
SQL BETWEEN Clause Syntax
Below is the syntax of the SQL BETWEEN clause:
SELECT col1, col2, col3, ...., colN FROM table_name WHERE column_name BETWEEN val1 AND val2;
To achieve detail knowledge about SQL BETWEEN clause, refer to SQL Between
SQL LIKE Clause Syntax
Here is the syntax of the SQL LIKE clause:
SELECT col1, col2, col3, ..., colN FROM table_name WHERE column_name LIKE {PATTERN};
To get some detail knowledge about SQL LIKE clause, then refer to SQL Like
SQL GROUP BY Clause Syntax
Below is the syntax of the SQL GROUP BY clause:
SELECT SUM(column_name) FROM table_name WHERE CONDITION GROUP BY column_name;
To learn more about SQL GROUP BY clause, refer to SQL Group By
SQL ORDER BY Clause Syntax
Below is the syntax of the SQL ORDER BY clause:
SELECT col1, col2, col3, ..., colN FROM table_name WHERE CONDITION ORDER BY column_name{ASC|DESC};
To learn more about SQL ORDER BY clause, refer to SQL Order By
SQL DROP TABLE Statement Syntax
Here is the syntax of the SQL DROP TABLE statement:
DROP TABLE table_name;
To learn more about SQL DROP TABLE statement, refer to SQL Drop Table
SQL CREATE TABLE Statement Syntax
Here is the syntax of the SQL CREATE TABLE statement:
CREATE TABLE table_name( col1 datatype, col2 datatype, col3 datatype, ..... colN datatype, PRIMARY KEY(one or more columns) );
To learn in detail about SQL CREATE TABLE statement, refer to SQL Create Table
SQL CREATE INDEX Statement Syntax
The syntax of the SQL CREATE INDEX statement is shown here:
CREATE UNIQUE INDEX index_name ON table_name(col1, col2, col3, ..., colN);
To learn more about SQL CREATE INDEX statement, refer to SQL Create Index
SQL DELETE Statement Syntax
The syntax of the SQL DELETE statement is shown here:
DELETE FROM table_name WHERE {CONDITION};
To learn in detail about SQL DELETE statement, refer to SQL Delete
SQL UPDATE Statement Syntax
The syntax of the SQL UPDATE statement is shown here:
UPDATE table_name SET col1 = val1, col2 = val2, col3 = val3, ..., colN=valN [WHERE CONDITION];
To learn in detail about SQL UPDATE statement then refer to SQL Update
SQL CREATE DATABASE Statement Syntax
The syntax of the SQL CREATE DATABASE statement is shown below:
CREATE DATABASE database_name;
To achieve more knowledge about SQL CREATE DATABASE statement then refer to SQL Create Database
SQL DROP DATABASE Statement Syntax
Following is the syntax of the SQL DROP DATABASE statement:
DROP DATABASE database_name;
To learn in detail about SQL DROP DATABASE statement, refer to SQL Drop Database
« Previous Tutorial Next Tutorial »
Like/Share Us on Facebook 😋