Using order by in the select query

[Former Member]

Hi All,

I have query in which I need the latest record. To get the latest record, I can

1) Select all entries into an internal table and sort them descending and get the first one

2) Select all entries into an internal table and order by in the select statement itself.

Then read the first one.

Which approach should be better as for as the performance is concern.

The query is on MKPF table and I have the material document number. I need the latest entry.

Regards,

Shahu

[Former Member]

Hi All,

I have query in which I need the latest record. To get the latest record, I can

1) Select all entries into an internal table and sort them descending and get the first one

2) Select all entries into an internal table and order by in the select statement itself.

Then read the first one.

Which approach should be better as for as the performance is concern.

The query is on MKPF table and I have the material document number. I need the latest entry.

Regards,

Shahu

[Former Member]

Hi

Try SELECT MAX(datum) ... command

Anyways your first option seems fine. Its not the fastest solution, but surely will work.

Regrds

Tamá

[Former Member]

first one because order by in select make your performance decrease.

regards

shiba dutta

[Former Member]

ORDER BY is obsolete.

The second approach is better when if you need maximum for each documnt.

you can directly use the

select max * if you need only the maximum of all.

Regards,

Ravi

[Former Member]

Hi,

The first one would be better.At the most we should not use order by in select statement bcoz it directly sorts the data according to that in database itself reverting performance issues.

Otherwise you can use select max* if records are less.

Reward points if helpful.

Thanks,

Ponraj.s.

[Former Member]

Thank you all...

Regards,

Shahu