Archives of the TeradataForum

Message Posted: Tue, 05 Aug 2003 @ 16:14:59 GMT

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

<-- Anonymously Posted: Tuesday, August 05, 2003 12:10 -->

Are you looking at something like this

select emp_no, sal, rank(sal desc) x
from emp
qualify x <6

Rgds

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