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 distinct eid from employee| EID | 893 | 1896 | 6725 | 672 |
|---|