SQL_Aliases2.htm
Distinct : aliases
Query :

select distinct(e.deptno), d.dname from emp e, dept d where e.deptno = d.deptno

Oracle

PostGreSQL

MySQL