SQL SELECT DISTINCT

Generally SQL SELECT statement returns rows from one or more tables.

In order to get the Unique or Distinct records, a DISTINCT keyword used along with SELECT.

Syntax:

SELECT DISTINCT * FROM TABLE_NAME

or

SELECT column1, column2 FROM TABLE_NAME

34 views

Return to top