Friday, 7 April 2017

how to get nth highest salary in mysql

select price from (select  price  from products order by price desc LIMIT 1) result order by price LIMIT 1

No comments:

Post a Comment