Write a query to fetch unique records from a database

A database query challenge testing SQL skills, focusing on data retrieval and elimination of duplicate records. Typical approach involves using DISTINCT keyword or GROUP BY clause to ensure unique record selection.