How can I SELECT unique records, along with the id column, but have DISTINCT ignore it when querying?

Question

MySQL

The problem is that the id column makes all records unique, and there is no point in DISTINCT * .
Something like this is needed:
SELECT (id), (DISTINCT a, b, c) FROM table
Unfortunately, group by a, b, c is too long, there are a lot of records in the database.
Help find a way out.

Answer 1

Your ID does not participate in DISTINCT:
Remember that Distinct must always come first

Answer 2

As an option, you can try like this:
SELECT id, p1, p2 FROM table
WHERE IN p1 IN (SELECT DISTINCT p1, p2 FROM table)
The main thing is that the set of linked fields be unique.