|
Archives of the TeradataForumMessage Posted: Fri, 09 Dec 2005 @ 10:27:05 GMT
Thanks Larkins for our response: But I tried this and this does not work because the subquery SEL count(*) FROM Returns more then one rows and then the Query fails giving the error Error: More then one value was returned by a sub query and also we cannot use Ordered Analytical functions i.e. row number() in sub queries. Appreciate if get any other solution... Thanks & regards, Saurabh gupta
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||