jeudi 21 juillet 2016

Select entire row as well as third highest salary

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