THIS CODE WORKS- select distinct emp.deptno, dname from emp,dept where dept.deptno=emp.deptno; BUT THIS WOULDNT select emp.deptno, distinct dname from emp,dept where dept.deptno=emp.deptno; ANY INSIGHTS?? Thanks.
Joined: Nov 24, 2001
It's an SQL thing - the word DISTINCT refers to the entire row, not just one column. As such, it belongs, syntactically, before the list of all columns.
Joined: Jun 09, 2003
got it. distinct is single row function. thanks buddy
Howdidly ho neighbo[u]r, and welcome to the Ranch! We hope you’ll enjoy pounding back pints of java help on a regular basis. However, we do have one piddly diddly little rule around these parts. Please change your display name to one that satisfies our piddly diddly little rule( naming policy - The skinny of the policy: just use a real firstname, followed by a space and a real lastname ). That's all! Thanks again and we hope to see you ordering up pints of java help on a regular basis! Jamie