Oracle DISTINCT Clause

Oracle DISTINCT clause is used to remove the duplicate records from the result set. It ensures that rows returned are unique for the column or columns specified in the SELECT clause.

The following illustrates the syntax of the SELECT DISTINCT statement-


SELECT DISTINCT expressions  FROM tables  WHERE conditions;  

Parameters:

expressions:It specifies the columns that you want to retrieve.

tables: It specifies the table from where you want to retrieve records.

conditions: It specifies the conditions that must be fulfilled.

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

About Mariano

I'm Ethan Mariano a software engineer by profession and reader/writter by passion.I have good understanding and knowledge of AngularJS, Database, javascript, web development, digital marketing and exploring other technologies related to Software development.