Use SOQL query to fetch the second maximum amount record of opportunity

• Use ORDER BY clause to sort the records by amount in descending order

• Use LIMIT 2 to fetch the top 2 records

• Use OFFSET 1 to skip t...read more