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;
Hey Shraddha, I understand your doubts about fetching ...READ MORE
This statement allows conditional update or insertion of ...READ MORE
Simple SQL queries can be used to ...READ MORE
The USE statement is used to mention ...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
This use of quotes is called delimited ...READ MORE
With the help of the SQL count ...READ MORE
To display the name of the employees ...READ MORE
OR
Already have an account? Sign in.