write query for fourth maximum salary from employee table
Answer Posted / yogendra barode
Select top 1 salary from (select top 4 salary from tbl_emp
order by salary desc) temp_tbl order by asc
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Can we return Data from 4(more than 1) tables in stored procedure?
What are advantages of ssrs or why we should use ssrs?
Explain what is lock escalation and what is its purpose?
Explain tables in SQL Azure?
What is the report model project?
Explain data warehousing in sql server?
What are the differences between sql server and mysql.
What is the use of custom fields in report?
what data regions are and what are the different data regions?
How to populate a table in sql server?
Does union all remove duplicates?
Why variables called the most powerful component of ssis?
What is user-defined inline table-valued function?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is the osql utility?