Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24502 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / raman
select top 1(esal) from (select top 2(esal) from employee order by esal desc) employee order by esal asc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List the ways in which dynamic sql can be executed?
Do you know spatial data types - geometry and geography in sql server 2008?
What are the differences between user defined functions and stored procedures?
What does sql server mean?
Explain the use of keyword with encryption. Create a store procedure with encryption?
What are the advantages of mirroring?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What are diverse clauses that form a part of sql?
What are the acid properties?
What it means to be triggered?
Explain the difference between function and stored procedure?
What is a data source file?
How does using a separate hard drive for several database objects improves performance right away?
What is normalization and denormalization in sql server?
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?
