22535/what-query-third-highest-salary-employee-from-employee-table
try this
SELECT TOP 3 salary
FROM(
SELECT TOP 1 salary
FROM Employee_Table
ORDER BY salary DESC) AS emp
ORDER BY salary ASC;
You can try out something like this:
SELECT TOP 1 salary FROM( SELECT TOP 3 salary FROM employee_table ORDER BY salary DESC) AS emp ORDER BY salary ASC;
If you want to find nth Salary ...READ MORE
I want to host a SQL server ...READ MORE
I was recently requested to create a ...READ MORE
Hey Shraddha, I understand your doubts about fetching ...READ MORE
The easiest way to work this out ...READ MORE
You can connect your Java code with ...READ MORE
There are really three major reasons: Inefficiency in ...READ MORE
Single quotes are used to indicate the ...READ MORE
With the help of the SQL count ...READ MORE
Select ename From emp Where ename like"s%"; READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.