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
What is after dml trigger?
What is filtered index?
Define views.
What is partition index in sql server?
Explain about nested stored procedure?
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?
Explain index in sql server?
What are the different editions available in sql server 2000?
What does select 1 mean?
What is the filtered index?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What is meant by referential integrity?
What is data source in connection string?
What is query parameter in ssrs?
What is triggers and stored procedures?