Archives of the TeradataForum

Message Posted: Wed, 03 Jun 2009 @ 10:08:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Chaim,

You can use RANK function.

     Select NAME, DEPARTMENT
      from   TEST
     Qualify RANK() OVER (Partition By DEPT Order by NAME desc) = 1

(You can sort with some other key instead of NAME e.g. EMPLOYEE_ID etc which would be a better idea)

Hope this helps!

Lakhwant Singh
Certified SQL Specialist

	<Prev	Next>		<<First	<Prev	Next>	Last>>