topic Re: Sort a DB table in Application Development and Automation Discussions

Sort a DB table

Former Member — Wed, 25 Nov 2009 07:01:08 GMT

Hello Experts,

Could you please tell me how to sort a Data base table.. The "SORT " in ABAP works on the internal table.. but how do i sort a Database table..

Please help..

Thanking you in advance.

Regards/-

Tamanna K

Re: Sort a DB table

Former Member — Wed, 25 Nov 2009 07:03:18 GMT

Hello,

But why do you want to do that?

Vikranth

Re: Sort a DB table

Former Member — Wed, 25 Nov 2009 07:04:50 GMT


> Hello Experts,
> 
>  Could you please tell me how to sort a Data base table.. The "SORT " in ABAP works on the internal table.. but how do i sort a Database table..
> Please help..
> 
> 
> Thanking you in advance.
> 
> Regards/-
> Tamanna K

hmm...strange requirements!!!,Strange Becuase already the data exists in sorted order in the database based on its primary key fields...

Could you please tell me why you need to sort a DATABASE table??

Vishwa.

Re: Sort a DB table

Former Member — Wed, 25 Nov 2009 07:06:25 GMT

Hi Tamanna,

This idea looks quite vague. This isnt possible.

You can get the data into an internal table & manipulate as per your requirement.

Hope it helps.

Cheerz

Abhii

Re: Sort a DB table

former_member206377 — Wed, 25 Nov 2009 07:07:10 GMT

Use ORDER BY in your select query

Or you can even select your data into an itab and then use SORT.

but if you want to sort the DB table itself, then i dont think it would be possible because the DB table rows are not held in any particular order, the order is applied when you fetch the data from the table.

Re: Sort a DB table

Former Member — Wed, 25 Nov 2009 07:07:10 GMT

Hi,

Rather sorting the database table,

You can Select the data from that

table into an internal table and then

sort that internal table by as many fields.

Hope it helps

Regards

Mansi

Re: Sort a DB table

former_member404244 — Wed, 25 Nov 2009 07:08:01 GMT

Hi,

once you see the contents of the db table in SE11 in the screen it self you can find sort either by ascending or descending. the fields ....

Please elaborate your requirement .. I don't see any need sorting a database table....

Regards,

Nagaraj

Re: Sort a DB table

Former Member — Wed, 25 Nov 2009 07:10:06 GMT

Thank you All

Regards,

Tamanna.