Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 23920 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
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
How to list all stored procedures in the current database using ms sql server?
Explain the steps to create and execute a user-defined function in the sql server?
Why truncate is ddl?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
what is database replicaion? : Sql server database administration
What is lock escalation and what is its purpose?
Why is the need for data conversion transformations?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Characterize join and name diverse sorts of joins?
Explain multiserver query
What is user defined stored procedures?
What is a matrix in ssrs?
How to find index size for each index on table?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the difference between resultset and resultsetmetadata?
