topic Re: SELECT query - problem with SORT in Application Development and Automation Discussions

SELECT query - problem with SORT

Former Member — Sun, 03 Feb 2008 20:07:48 GMT

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

Re: SELECT query - problem with SORT

Former Member — Mon, 04 Feb 2008 01:23:23 GMT

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

Re: SELECT query - problem with SORT

Former Member — Thu, 07 Feb 2008 12:38:14 GMT

Fetching data from customer table into internal table

Re: SELECT query - problem with SORT

Former Member — Thu, 07 Feb 2008 12:40:59 GMT

Hi,

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

Thanks,

Sriram Ponna.

Re: SELECT query - problem with SORT

Former Member — Thu, 07 Feb 2008 16:21:16 GMT

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

Re: SELECT query - problem with SORT

Former Member — Fri, 08 Feb 2008 15:00:08 GMT

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)

Re: SELECT query - problem with SORT

Former Member — Fri, 08 Feb 2008 15:08:24 GMT

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