topic Using order by in the select query in Application Development and Automation Discussions

Using order by in the select query

Former Member — Wed, 28 Feb 2007 10:19:34 GMT

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

Re: Using order by in the select query

Former Member — Wed, 28 Feb 2007 10:20:37 GMT

Try SELECT MAX(datum) ... command

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

Regrds

Tamá

Re: Using order by in the select query

Former Member — Wed, 28 Feb 2007 10:21:02 GMT

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

regards

shiba dutta

Re: Using order by in the select query

Former Member — Wed, 28 Feb 2007 10:22:04 GMT

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

Re: Using order by in the select query

Former Member — Wed, 28 Feb 2007 10:25:56 GMT

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.

Re: Using order by in the select query

Former Member — Wed, 28 Feb 2007 11:39:38 GMT

Thank you all...

Regards,

Shahu