CREATE TABLE employee(eid number(4), ename char(15), ework varchar(12))Table created.
INSERT INTO employee VALUES(893, 'Ritu', 'Accountant')1 row(s) inserted.
INSERT INTO employee VALUES(1896, 'Parv', 'Banker')1 row(s) inserted.
INSERT INTO employee VALUES(6725, 'Seema', 'Clerical')1 row(s) inserted.
INSERT INTO employee VALUES(672, 'Seema', 'Clerical')1 row(s) inserted.
INSERT INTO employee VALUES(1896, 'Parvesh', 'Banker')1 row(s) inserted.
select * from employee| EID | ENAME | EWORK | 893 | Ritu | Accountant | 1896 | Parv | Banker | 6725 | Seema | Clerical | 672 | Seema | Clerical | 1896 | Parvesh | Banker |
|---|
Select ename from employee where ework IN ('Banker', 'Clerical')| ENAME | Parv | Seema | Seema | Parvesh |
|---|
Select ename from employee where eid BETWEEN 820 AND 899| ENAME | Ritu |
|---|