SQL Commands with Syntax and Examples

INSERT OPERATION:

After creating the tables, namely EMPLOYEE and DEPARTMENT, we shall insert data values into them using SQL command. It has the following syntax:

INSERT INTO <table-name> VALUES(<value>, <value>, ...);

SELECT Command:

This command retrieves data from a table. This command also provides query capability. It has the following syntax:

SELECT * FROM <table-name>;