How to get second last record in a queryset in Django?

Question

I have a model named employees_salary and I need to get second highest salary of employee.

I know that I can filter latest(), first(), last()** and these are working, but how to filter second last? Am I missing something?

Answer 1

Use order_by with a reverse filter (-) and then grab the second object by using [1].

class Salaries(models.Model):

  employee_name = models.CharField(max_length=255)
  salary = models.IntegerField()


q = Salaries.objects.all().order_by('-salary')

second_highest_paid_name = q[1].employee_name

Answer 2

This way will also work

class EmployeeSalary(models.Model):    
    employee_name = models.CharField(max_length=255)
    salary = models.IntegerField()

#code for view
q = EmployeeSalary.objects.all().order_by('-salary')[1:1]
second_paid_name = q[0].employee_name
second_paid_salary = q[0].salary