topic Re: select second largest amount from a table in Application Development and Automation Discussions

select second largest amount from a table

Former Member — Tue, 07 Nov 2006 19:12:57 GMT

Hi All,

I want select second largest amount from a table . How i have to write a query for that?

Thanks,

Priya

RichHeilman — Tue, 07 Nov 2006 19:16:55 GMT

Well, I think you may need to get all of the data, then sort the amount column in descending order, then read line two of the internal table.

Regards,

Rich Heilman

Former Member — Tue, 07 Nov 2006 19:16:56 GMT

You could:

SELECT * from table
  into itab.
sort itab descending by field1.
read table itab index 2.

Rob

You'll have to check the syntax. I didn't.

Message was edited by: Rob Burbank

Former Member — Tue, 07 Nov 2006 19:18:03 GMT

You must write some extra logic for this:

data: begin of i_tbl occurs 0,

netwr like vbap-netwr,

end of i_tbl.

select netwr up to 2 rows from vbap into table i_tbl

order by netwr descending.

read table i_tbl index 2.

RichHeilman — Tue, 07 Nov 2006 19:22:11 GMT

John, I like that better. With the " up to 2 rows ". Nice.

Regards,

Rich Heilman

Former Member — Tue, 07 Nov 2006 19:22:17 GMT

John - I like yours better.

Rob

Former Member — Tue, 07 Nov 2006 19:29:37 GMT

Thank you, gentlemen.