0

var gr = new GlideRecord('your_table_name'); // Replace with your table name
gr.orderByDesc('amount'); // Sort in descending order
gr.query();
 var firstLargest = null;
var secondLargest = null;
 if (gr.next()) {
    firstLargest = gr.amount; // Get the largest value
}
 if (gr.next()) {
    secondLargest = gr.amount; // Get the second largest value
}
 gs.info('Second largest amount: ' + secondLargest);

Second largest value in the amount field using GlideRecord in ServiceNow
Working Code Asked question September 17, 2024