sql-basics/insert.sql at main · himansrivastava/sql-basics · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
DROP TABLE IF EXISTS EMPLOYEE;

CREATE TABLE EMPLOYEE (
    ID SERIAL PRIMARY KEY,
    FIRST_NAME VARCHAR(20) NOT NULL,
    LAST_NAME VARCHAR(20),
    AGE INTEGER,
    SEX VARCHAR(1),
    INCOME DOUBLE PRECISION
);

SELECT * FROM EMPLOYEE;


INSERT INTO EMPLOYEE
    (
        FIRST_NAME,
        LAST_NAME,
        AGE,
        SEX,
        INCOME
    )
VALUES
    (
        'HIMANSHU',
        'SRIVASTAVA',
        34,
        'M',
        150000.00
    ),
    (
        'ABHILASHA',
        'ROOPAM',
        33,
        'F',
        100000.00
    )
RETURNING *
;


INSERT INTO EMPLOYEE
    (
        FIRST_NAME,
        LAST_NAME,
        SEX,
        INCOME
    )
VALUES
    (
        'ABC',
        'DEF',
        'M',
        150000.00
    ),
    (
        'DEF',
        'ROOPAM',
        'F',
        100000.00
    )
RETURNING *
;

COMMIT;

SELECT * FROM EMPLOYEE;