Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120163 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / abhay
Select Max(Sal)
From Emp E
Where E.Sal < (Select Max(Sal) From Emp)
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How do you modify a trigger?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Explain the update statement in sql
Is it possible to update views?
What is cursor explain with example?
Where the sql database files are stored?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Can we have two clustered index on a table?
Can a composite key be null?
How many triggers can be applied to a table?
What is the difference between python and sql?
How to disable a trigger name update_salary?
What is the sql query to display the current date?
What is database migration?
