oracle中如何去掉重复的数据？

Question

我oracle数据库中的SQL语句是这样的：
select
t.pk_id pkId,
t.parent_pk_id parentPkId,
t.vc_create_userid createUserId,
t.VC_CREATE_USERID createTrueName,
t.vc_consumer_no consumerNumber,
t.vc_consumer_dep consumerDep,
t.vc_consumer consumer,
t.vc_phone_number phomeNumber,
t.vc_mobile_number mobileNumber,
t.vc_email email,
t.vc_address address,
t.cclog_id cclog,
t.callback_userid callBackUserId,
t.n_callbackrepeat callBackRepeat,
t.dt_cq_time cqTime,
t.n_over_use_time overUseTime,
t.n_urged_handle urgedHandleNumber,
t.cid cid,
t.yq_flag yqFlag,
t.ENTRY_ID entryId,
o.status taskState,
o.owner taskUserId,
o.owner_dept taskDeptId,
t1.dl_create_time dlCreateTime
from CRM_WORKFORM t
left join view_now_work_owner o on o.entry_id = t.entry_id
left join crm_workform_deal t1 on t.pk_id = t1.order_id
where t.vc_wf_state_code in('processed','visiting')

因为t1表中pkId一样的数据有多条，所以导致关联查出来的结果中有pkId重复的数据，请问如何去掉重复的一模一样的数据？

如图：

Answer 1

最简单的办法是 select distinct