select second largest amount from a table

[Former Member]

Hi All,

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

Thanks,

Priya

[RichHeilman]

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]

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]

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]

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

Regards,

Rich Heilman

[Former Member]

John - I like yours better.

Rob

[Former Member]

Thank you, gentlemen.