mysql - How to get 2nd highest salary from db -


to find highest salary db use max in query.

how 2nd highest salary db. can 1 suggest sq query

this should help:

select max(salary)  mytable salary < (    select max(salary) mytable ) 

Comments

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

git - How to list all releases of public repository with GitHub API V3 -

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -