mysql get nth highest
Solutions on MaxInterview for mysql get nth highest by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "mysql get nth highest"
Silvia
24 Sep 2017
1CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
2BEGIN
3 SET N = N-1;
4
5 RETURN (
6 # Where Salary is your column name and Employee your table
7 SELECT DISTINCT(Salary) FROM Employee ORDER BY Salary DESC LIMIT N, 1
8 );
9ENDsimilar questions
mysql max datemysql limit results to 10nth highest salary in sqlnth max in my sqlmysql limit rowslimit offset order by mysqlhow to find 2nd highest salary in mysqlselect nth row in mysqlmysql max 28 292nd highest salary in mysqlhow to take recent row without limit in mysqlmysql find max value rowmysql limit order bymysql order by rand limit 1 really slowmysql mediumint max valuesql select second maxhow to fetch highest score in minimum time using mysqlmysql limit and offsetmysql limitmysql maxsecond height salary mysqlmysql get max value and idmysql select row max datemysql query to select the highest value your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful