SELECT *FROM emp
ORDER BY Salary desc
WHERE rownum <= 3
ORDER BY Salary ;
I hope this helps you.
I was recently requested to create a ...READ MORE
If you want to find nth Salary ...READ MORE
The easiest way to work this out ...READ MORE
I have a table Emp which has these rows:
Emp_cd ...READ MORE
You have to convert the literal to ...READ MORE
Use an IN clause.
Depending upon the details of your script ...READ MORE
Nope. I don't think there is one
But ...READ MORE
Use ROW_NUMBER(if you want a single) or DENSE_RANK(for all ...READ MORE
A MySQL "database" can be compared to ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.