[GIS] How to make SQL definition query in ArcGIS to show only unique values (hide duplicates)

Question

I have a vector file with field of type LONG. Some values of this field are duplicates.

Is it possible to make such SQL definition query in ArcGIS 10.3 to show only unique values without duplicates?

Example data: 1, 2, 3, 3, 3, 4, 5, 1, 6

What I want: 1, 2, 3, 4, 5, 6

Picture examples:

1) Before definition query:

2) After definition query:

Answer 1

As commented by @Vince:

It is certainly possible, once the problem is better defined, to fashion a solution using SQL (leveraging a view), and Python would not be necessary

What seems to be missing from your question to attract a potential answerer is a response to @Vince's earlier comment:

Please edit this question to specify the RDBMS in use, clarify whether an enterprise geodatabase is present, and provide a complete definition of the table involved (including multiple rows of data). It's not likely that a definition query could solve this data modelling problem, but a different solution is likely possible once you've clearly defined the problem.