Archives of the TeradataForum
Message Posted: Thu, 27 May 2010 @ 20:42:59 GMT
You shouldn't use the old syntax anymore:
select FIELD1 from TEST.TABLE1 qualify rank() over (order by FIELD2 desc) =1
This might be an ODBC problem, did you submit it using SQL Assistant? Looks like the rank was snipped off.
Try it using BTEQ.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|