SQL Doubt

[Sirisha Reddy]

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.

[Dorothy Finkel-Laverty]

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.

[Sirisha Reddy]

got it. distinct is single row function.
thanks buddy

[Jamie Robertson]

Mr. Multeon:

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

[Sirisha Reddy]

I did.