Replacement of order by clause

Database

Replacement of order by clause

Hi,

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

5 REPLIES
Senior Apprentice

Re: Replacement of order by clause

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

Why do you ask for it?

Re: Replacement of order by clause

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 

Senior Apprentice

Re: Replacement of order by clause

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.

Re: Replacement of order by clause

Thanks Dieter.

Teradata Employee

Re: Replacement of order by clause

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