SELECT query - problem with SORT

[Former Member]

Hi,

Same select query behaves different way on development and quality server

on Development it returns unsorted and Quality returns sorted

it can be resolved by SORT but why does it behave differently

Do you know what is setting in database

thanks

[Former Member]

Can you please tell on what table you getting the sorted result.

[Former Member]

Fetching data from customer table into internal table

[Former Member]

Hi,

You need to explicitly handle in your ABAP code, nothing to do with database.

Thanks,

Sriram Ponna.

[Former Member]

From F1 on SELECT:

Orders the records in a SELECT statement. Without the ORDER-BY clause, the order
 in which the selected lines are supplied is undefined. This means that two similar SELECT
 statements may produce lines in a different order. 

Rob

[Former Member]

Thanks . Does ORDER BY clause is a part of database default setting if yes where ?

(same SELECT statement without ORDER BY clause fetches same records but in different order in both server)

[Former Member]

I don't use the ORDER BY option. I think it's better to have the application do it. I don't know of any way to make it automatic.

Rob