Eliminating Duplicate Data Using DISTINCT : DISTINCT « Select Query « Oracle PL / SQL






Eliminating Duplicate 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> 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> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn) VALUES (6,6,3,DATE '2003-03-25');

1 row created.

SQL>
SQL>
SQL> SELECT DISTINCT SustainedOn FROM emp;

SUSTAINED
---------
11-MAR-03
12-MAR-03
13-MAR-03
18-MAR-03
19-MAR-03
25-MAR-03

6 rows selected.

SQL>
SQL>
SQL> drop table emp;

Table dropped.

   
  








Related examples in the same category

1.Remember that the DISTINCT operator applies to the entire select list
2.DISTINCT: Eliminating duplication in the result set
3.DISTINCT operator inside a group function
4.DISTINCT clause can be used with more than one field
5.Eliminating Duplicate Date type Data Using DISTINCT
6.Count distinct with group by
7.DISTINCT tableName.*
8.Distinct city and state