A.unique B.distinct C.order by D.group by
A.where ename like ‘_HOT%’ B.where ename like ‘H_T%’ C.where ename like ‘%TKA_’ D.where ename like ‘%TOK%’