Different ways to get unique records from a table

• Distinct
• Unique
• Group by of all columns
• Union of same columns of same table
• Union of null columns from dual table
• Intersect the same table query
• Minus the query with null records of dual

Reference :

Example 1