Chapter 3, Problem 8RQ

Explanation of Solution

SELECT statement:

It is used to retrieve information from the table or database. The syntax for the “SELECT” statement is given below:

Syntax:

SELECT * FROM table_Name;

 Example:

Creating table “EMP_1”:

 CREATE TABLE EMP_1 ( EMP_NUM CHAR(3) , EMP_LNAME VARCHAR(15) , EMP_FNAME VARCHAR(15) , EMP_INITIAL CHAR(1), EMP_HIREDATE DATE, JOB_CODE CHAR(3));

Inserting values into the table “EMP_1”:

INSERT INTO EMP_1 VALUES ('101', 'News', 'John', 'G', ' 2000-11-08', '502');

INSERT INTO EMP_1 VALUES ('102', 'Senior', 'David', 'H', ' 1989-07-12', '501');

Explanation:

• The above query is used to create a table structure named “EMP_1” ...