|
Archives of the TeradataForumMessage Posted: Wed, 07 Dec 2005 @ 11:35:51 GMT
Hi, Can we use the Qualify() function along with the Delete query? The query goes like this /********************************************************/ Delete FROM Table1 Where ( Primary index columns ) IN (SEL Primary index columns FROM Table1 Where some_condition and Having count (*) >1 Group by Primary index columns) Qualify row_number () OVER (partition BY Primary index columns Order by column asc) =1; Error 3706: expected something between ')' and the 'Qualify' Keyword /********************************************************/ If we replace the 'Delete' by 'Select' keyword then it returns the needed rows but delete doesn't work.. Please help me in this problem. Thanks & Regards, Saurabh gupta
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||