All Forums Database
singh.ritesh5 3 posts Joined 02/14
12 Feb 2014
Replacement of order by clause

Hi,
Can we replace order by clause with any other command in teradata.Thanks.

dnoeth 4628 posts Joined 11/04
12 Feb 2014

No, you can't do that in any DBMS. WIthout ORDER BY there's no guaranteed order.
Why do you ask for it?

Dieter

singh.ritesh5 3 posts Joined 02/14
17 Feb 2014

Thanks Dieter, I ask this because I came to know for teradata V14 Order by will not work in sub query and we have Parm in which order by is being used in subquery with partition clause in rank function.
Ritesh 

dnoeth 4628 posts Joined 11/04
17 Feb 2014

Hi Ritesh,
i'm not aware of any change regarding Order By in subqueries in TD14.
Order By in RANK is just a logical sort and you query should run as-is in TD14.

Dieter

singh.ritesh5 3 posts Joined 02/14
17 Feb 2014

Thanks Dieter.

Adeel Chaudhry 773 posts Joined 04/08
17 Feb 2014

It works without any change. We are using it on TD 14.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.