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