topic using order by statement !! in Application Development and Automation Discussions

using order by statement !!

Amey-Mogare — Fri, 01 Feb 2008 05:02:27 GMT

Hi,

I'm using following query in my RFC:-

SELECT *

FROM Transactions

UP TO 30 ROWS

WHERE TR_ID >= l_current_tid AND

PHASE = l_phase.

Now I want to ensure that this table Transactions is ordered by TR_ID before this query is executed..

How do I achieve this? Pls help me on this.

Awaiting for reply.

Regards,

Amey

Former Member — Fri, 01 Feb 2008 05:05:50 GMT

Hope it will help you,.

Pls reward if help.

SELECT CARRID CONNID MIN( SEATSOCC ) AS MIN

INTO CORRESPONDING FIELDS OF WA

FROM SFLIGHT

GROUP BY CARRID CONNID

ORDER BY CARRID MIN DESCENDING.

WRITE: / WA-CARRID, WA-CONNID, WA-MIN.

ENDSELECT.

Amey-Mogare — Fri, 01 Feb 2008 05:22:09 GMT

Thanks for quick reply..

But im using UP TO statement in query so what is happening is

1. it is first selecting all matched lines

2. Then ordering them by ORDER By condition

3. and then, returning 30 lines out of them..

So I want to sort the table first and then apply the select query..

I hope this better explains my problem..

Regards,

Amey

Former Member — Fri, 01 Feb 2008 05:22:54 GMT

1.SELECT the required rows from the database into ITAB without using ORDER BY

2. sort the ITAB

3. Fetch the required data from the ITAB

Note: If u use ORDER BY in SELECT , performance will go down

Narendra