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


Please Help Members By Posting Answers For Below Questions

What is after dml trigger?

580


What is filtered index?

660


Define views.

599


What is partition index in sql server?

610


Explain about nested stored procedure?

608






after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1694


Explain index in sql server?

600


What are the different editions available in sql server 2000?

592


What does select 1 mean?

536


What is the filtered index?

565


If you want to send some data from access database to sql server database. What are different component of ssis will you use?

512


What is meant by referential integrity?

596


What is data source in connection string?

495


What is query parameter in ssrs?

119


What is triggers and stored procedures?

519