Eliminating Duplicate Date type Data Using DISTINCT
SQL> SQL> SQL> CREATE TABLE emp ( 2 empID INT NOT NULL PRIMARY KEY, 3 CourseID INT NOT NULL, 4 ProfessorID INT NOT NULL, 5 SustainedOn DATE, 6 Comments VARCHAR(255)); Table created. SQL> SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (1,1,1,DATE '2003-03-12','Hard'); 1 row created. SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (2,2,1,DATE '2003-03-13','Simple'); 1 row created. SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (3,3,2,DATE '2003-03-11','1 hour long'); 1 row created. SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn) VALUES (4,4,3,DATE '2003-03-18'); 1 row created. SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (5,5,2,DATE '2003-03-19','2 hours long'); 1 row created. SQL> SQL> SELECT DISTINCT empID, SustainedOn FROM emp; EMPID SUSTAINED ---------- --------- 1 12-MAR-03 2 13-MAR-03 3 11-MAR-03 4 18-MAR-03 5 19-MAR-03 5 rows selected. SQL> SQL> drop table emp; Table dropped.