DISTINCT doesn't work can anyone help me?
565927Sep 27 2007 — edited Sep 27 2007Hi i am new to SQL and i have a problem with a query.I have joined two tables and expected
distinct rows. How can i retrieve distinct columns from database.
select DISTINCT d.dname,e.empno,e.ename from emp e,dept d where e.deptno=d.deptno
no order by empno;
any help will be greatly appriciated