Multiple Fields in the Oracle database using distinct

SelectDISTINCT (t. f_resume_id | t. f_resume_status), t. f_resume_status, t. f_resume_status, t. f_recruit_channel, t. f_sma

Select DISTINCT (t. f_resume_id | t. f_resume_status), t. f_resume_status, t. f_resume_status, t. f_recruit_channel, t. f_sma

Select DISTINCT (t. f_resume_id | t. f_resume_status), t. f_resume_status, t. f_resume_status, t. f_recruit_channel,
T. f_small_channel_id
From css. T_RESUME_INFO t where t. f_resume_status in (80011,80012)

Multiple distinct fields. Of course, the same function can be completed by group.
Select a, B, c, min (d) d
From
Group by a, B, c

You can use group to return the same results. You do not need to use distinct.
Efficiency of the two. It is best to use the group by statement when necessary. The group by statement is used for grouping statistics, so do not use the group by statement when disitnct is used.

Excerpt from netizens:
Nested with group by and rownum, but high efficiency of distinct

,