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 eid, ename from employee where ework= 'Clerical' order by ename asc| EID | ENAME | 672 | Seema | 6725 | Seema |
|---|