Archives of the TeradataForum
Message Posted: Tue, 24 May 2005 @ 12:23:08 GMT
Use can try the rank function to identify the most recent last_dt.
select emp_name, emp_id, last_dt from employee K1 QUALIFY RANK(last_dt) = 1;
You may have to use (last_dt DESC) to get the max date, I always have to play with it to get the dates in the order I want.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|