Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 61274 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / savita vishwakarma
select max(sal)
from (select rownum
from emp
order by sal desc)
where rownum=2
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
How to insert data with null values?
What is faster join or union?
How do I view a stored procedure in sql server query?
How does the report manager work in SSRS?
What is cached report?
What different steps will a sql server developer take to secure sql server?
What is table level trigger?
What are different types of replication in sql server?
What do you mean by an execution plan? Why is it used?
what is a deadlock? : Sql server database administration
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Tell me something about security and sql azure?
Explain nested join?
Explain boyce and codd normal form(bcnf)?
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? : Sql server administration
