Select DISTINCT
A.a a, a. b, a.c c
The from
Tbl1 a,
Tbl1 b
Where
(a. d. d>=b.d d)

CodePudding user response:

Is there a big solve

CodePudding user response:

This answer and select aa, bb, cc from the same tbl1
Why do you want to write like this? Or a test question, the principle of two table join you?

CodePudding user response:

A bit odd, which is the source?

CodePudding user response:

And the following, is exactly the same,
Select DISTINCT
A.a a, a. b, a.c c
The from
Tbl1 a.

CodePudding user response:

Meaningless judgment conditions, the results should be the same,