Php and MySQL

Question

Hello friends

In Ms Excel we have a LARGE function which can be used to get the nth large number in an array. Now how can I do this task in MySQL? I have an array with 9 elements but i want to get the sum of only seven large numbers

Answer 1

SELECT SUM(elements) FROM table ORDER BY elements desc LIMIT 7

Answer 2

Thank you Gordon