Archives of the TeradataForum

Message Posted: Thu, 13 Jun 2002 @ 10:35:59 GMT

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

But be aware, that by default still ALL rows are transferred and just discarded by BTEQ. You have to set RETCANCEL to avoid that.

You could also use following query from all clients:

SELECT JahrWoche , Lagerbestand
FROM NGT_Lagerbestand
WHERE ArtikelNr = '10011000' AND JahrWoche < 200217
AND Lagerbestand IS NOT NULL
QUALIFY RANK(JahrWoche) = 1

or in R4 SQL-99 compliant:

QUALIFY RANK() OVER (ORDER BY JahrWoche DESC) = 1

If Jahrwoche is not unique there may be more than one row in your result set. To avoid this, add more columns to the rank.

Dieter

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