0

Php and MySQL

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

23rd Apr 2020, 3:46 AM
Hamimu Said
2 Answers
+ 2
SELECT SUM(elements) FROM table ORDER BY elements desc LIMIT 7
23rd Apr 2020, 4:57 AM
Gordon
Gordon - avatar
0
Thank you Gordon
23rd Apr 2020, 5:53 AM
Hamimu Said