Find Nth record from the query by using slice operator except using first() and last()
e.g
user = User.objects.order_by('-last_login')[2] // Second Highest record w.r.t 'last_login'
Sql query will look like this:
SELECT "auth_user"."id","auth_user"."password",
"auth_user"."last_login",
"auth_user"."is_superuser",
"auth_user"."username",
"auth_user"."first_name",
"auth_user"."last_name",
"auth_user"."email",
"auth_user"."is_staff",
"auth_user"."is_active",
"auth_user"."date_joined"
FROM "auth_user"
ORDER BY "auth_user"."last_login" DESC
LIMIT 1
OFFSET 2