Archives of the TeradataForum
Message Posted: Thu, 13 Jun 2002 @ 10:35:59 GMT
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
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|