|
Archives of the TeradataForumMessage Posted: Fri, 05 Dec 2008 @ 10:42:17 GMT
Can someone tell me the following query can be converted to a delete statement: SELECT RUN_DT, RANK() OVER (ORDER BY RUN_DT) FROM DB.forecast_table WHERE FRC_CD = 52 GROUP BY RUN_DT QUALIFY RANK() OVER (ORDER BY RUN_DT) >24 Is it possible to use RANK in a DELETE statement? Thanks, Bob
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||