I need to fetch all row details of user with third highest salary.
My query
select min(salary)as minsalary from (select * from userdetails
order by salary desc limit 3) as details
Current output :-
Array
(
[0] => stdClass Object
(
[minsalary] => 300
)
)
i need to fetch the full row details too along with this array as single array output. How can i alter my query.
Please help.
Aucun commentaire:
Enregistrer un commentaire