Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24431 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / icedrop
select top 1 salary from (select distinct top 4 Salary from tablename order by salary desc ) result order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to how to convert numeric expression data types using the convert() function??
SQL Server Architecture ?
Explain throw statement in sql server 2008?
Why use “in” clause in sql server?
What are statistics?
Explain the concept of recursive stored procedure.
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Explain how to use linked server?
What is join query?
Determine how to use the inserted and deleted pseudo tables?
Write an sql query for deleting duplicate rows?
Explain syntax for viewing trigger?
your distribution database is full what will u do
What is a view and what are its advantages?
Explain in brief how sql server enhances scalability of the database system?
